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...
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...
by Abhijith DSouza | Nov 18, 2020 | Power BI
In this post we will discuss how to transform a basic line and column chart into a chart which prompts the user to take action. We have line and column chart below which shows daily sales as columns and an average daily sales line (Day number of month as Axis and...
by Abhijith DSouza | Nov 7, 2020 | Power BI
In the previous post we saw how duplication of effort was one of the biggest issues facing companies which are deploying a Power BI solution. Duplication of effort leads to: Wasted hours – Time spent on duplicating dashboards can be spent on more value add work...
