Brisbane, 4000 QLD

+61 4 3836 7017

User selected labels

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...

Alternate way to show month on month trend

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...

Transforming a heatmap using a single line of DAX

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...

Transforming a line and column chart

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...