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 | 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...
by Abhijith DSouza | Nov 19, 2020 | Power BI
Heatmaps are a great way of showing complex data in an easily understandable manner. In a heatmap, you have rows and columns and at the intersection of each row and column you have a value. Typically you are not interested in the individual values and want to see the...
