by Tony Tan | Nov 29, 2022 | Tony Tan
Boring with creating normal bar charts? A bar chart with a customized shape could be an option. If you want to create a bar chart with a customized shape, the first step is to determine the color of your dashboard background. In this example, I choose the color as...
by Tony Tan | Nov 29, 2022 | Tony Tan
As mentioned in the last blog, to allow users to add new dimensions to the table without adding the context filter to the measure, we can use ALLEXCEPT function. To summarize our requirement now, we want the measure we created to be only filtered by the state no...
by Tony Tan | Nov 29, 2022 | Tony Tan
This blog will explain how we can use the context filter function in Power BI. The DAX statements used in this blog are ALL, ALLEXCEPT and ALLSELECTED. The dataset applied in this blog is Sample Superstore which you can be easily found in the tableau repository....
by Tony Tan | Nov 22, 2022 | Tony Tan
It comes to the Day 3 of the Dashboard Week. Today, I created an exploratory dashboard that enables users to pick up their favorite Brewdog Beer. At the very top of the dashboard, you will see four metrics that show the average value of different Brewdog beers like...
by Tony Tan | Nov 22, 2022 | Tony Tan
In Day 4 Dashboard Week, we were given a dataset of endangered animal. I created a dashboard called global trade of endangered animal. To build this dashboard, I integrated the data from https://trade.cites.org/ which contains the global trade of endangered animal. At...
by Tony Tan | Oct 17, 2022 | Tony Tan
This article will show some basic spatial calculations of creating a flight route map in tableau. The dataset used as demonstration contains the following fields. This map is basically to show all the routes from the same original airports. Before creating the...