by Abhijith DSouza | Feb 1, 2022 | Power BI
This post is inspired by a blog in which the author showcased the visualisation of % top city sales for a region in Tableau. I thought the solution provided was cumbersome so decided to visualise it in Power BI. It turns out that the DAX for this is straightforward...
by Abhijith DSouza | Nov 20, 2021 | Power BI
Filtering a visual in Power BI by TOPN or BOTTOMN is very easy. You apply a visual level filter and specifiy how many TOP/BOTTOM values you wan to see in your visual. Things get complicated however when there is a hierarchy present in the visual.The TOPN filter will...
by Abhijith DSouza | Sep 25, 2021 | Power BI
To label or not to label. Labelling of values in a line/bar chart in a dashboard is a contentious issue. Stakeholders coming from the world of static reports in Excel/pdf are used to seeing labels on charts and want the same functionality in Power BI. They do not want...
by Abhijith DSouza | Aug 1, 2021 | Power BI
When we are visualising month on month trends for a single year the normal way to represent it is to show the months in the X axis and the data you want to visualise (say sales) in the Y axis. It would look something like this. Here we are plotting Total Sales versus...
by Abhijith DSouza | Feb 25, 2021 | Power BI
Calculations groups are a collection of calculation items which are defined as base measures to easily calculate (mostly) time intelligence functions such as YTD, MTD, QTD without explicity writing such measures for each metric in the model. You can have multiple...