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 | 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 | Jun 6, 2020 | Power BI
Suppose you have a landing page and you have a bunch of slicers on the page and you want the users to select at least one option on the slicers before they can enter the next page. It wasn’t possible with bookmarks before as you couldnt switch bookmarks using...
by Abhijith DSouza | Mar 27, 2020 | Power BI
Data storytelling is increasingly being seen as essential to modern data analysis It is no longer enough to just develop a data model and produce visuals and let the audience take it from there. Reports need to be developed with the end user in mind while taking them...
