How To Guides
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 reading
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 reading
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 reading
How to create a table with a bar graph in it? 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, Month and Day from my Date hierarchy (in the values section […]
Continue reading
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 reading
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 reading
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 reading
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