Do you know how to create Dynamic TOP N in Tableau? Follow along to the video or check out the steps below. Let’s create a control to dynamically change the number of rows we want to see in our graph. Create a new parameter called “Top N” and set the type to Integer and the […]
Continue readingCategory Archives: How To Guides
How To Guides
Dynamic Categories and Legends in Tableau
Do you know how to create Dynamic Categories and Legends in Tableau? Follow along to the video or check out the steps below. Dynamically selecting the measures values and legends. If you want to compare different categories values in a chart and want to select them dynamically, this is a simple and efficient way of […]
Continue readingComparing selected and previous months in Tableau
Do you know how to compare selected and previous months in Tableau? Follow along to the video or check out the steps below. Let’s compare the selected month with the previous month. Create a calculated field named “Order Month” with the following formula: DATE(DATETRUNC(‘month’, [Order Date])) Create a parameter named “Date” with: Data type: Date […]
Continue readingHow to dynamically delete multiple header rows in Power BI
Do you know how to dynamically delete multiple header rows in Power BI? Follow along to the video or check out the steps below. Have you ever been in a situation that you have an excel file with nested column headers, and you want them to be correctly ingested in your dashboarding tool? And to […]
Continue readingHow to create a table with a bar graph in Power BI
How to create a table with a bar graph in it? Follow along to the video or check out the steps below. In a Power BI page, add a new “Table” visual: Now drag and drop the fields Date, Subdivision and Business Unit in the Values section of the table: I removed the Quarter, […]
Continue readingHow to create a map in Power BI
Do you know how to create a map in Power BI? Maps are perhaps one of the most engaging visuals on any dashboard. Creating a map in Power BI is a breeze. Follow our step by step approach in the video or below to see how it’s done. In a Power BI page, insert […]
Continue readingHow to create a shaded map in Tableau
In this quick tutorial, I’ll show you how to create a shaded map in Tableau. Tableau automatically recognizes the Country, State and City as a hierarchy and their geographical roles which makes creating a map quite easy. Also, Tableau generates the Latitude and Longitude for us, according to those geographical roles, saving us a lot […]
Continue readingHow to show a graph in a tooltip with Tableau
Ever wondered how to show a graph in a tooltip with Tableau? In this example, I’ll show a very simple and quick example of how you embed a graph in another graph’s tooltip. Suppose you have a graph that shows the revenue and the forecasted revenue over time but I want to show more detail […]
Continue readingHow to create a stacked bar and a line in Tableau
Have you ever struggled to create a Tableau chart with stacked bars and a line over a period of time? Open Tableau and follow these instructions: 1. Drag and drop your date pill on your Columns shelf, right click on it and select “Exact Date”. 2. Tableau will transform it in Continuous, […]
Continue reading