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...
by Abhijith DSouza | Jan 9, 2021 | Power BI
Bookmarks are a great way to story tell in Power BI as they can be used to save pre configured states in a report. However they have drawbacks in that you have to create two versions of a button for each bookmark and show/hide one of them depending on the bookmark...