Brisbane, 4000 QLD

+61 4 3836 7017

Blog

Strategic colouring in Power BI – Part 4: Isolating and visualising YTD data

This is the fourth post in the Strategic colouring in Power BI series. Links to all the posts can be found here https://www.capstoneanalytics.com.au/master-post-for-strategic-colouring-articles/ In the previous post, we looked at how to isolate a category in a trend We will add on this in this post and see how to ...
Read More

Change line colour based on values in a disconnected table

Power BI works on great relationships, but sometimes we need to solve a problem without any relationships. Enter the disconnected tables. These are very useful to solve specific problems. They are easy to set up and you can be as creative as you want with your DAX to achieve your ...
Read More

Get users to select the colours in your reports

Deciding which colours to use in a report is never an easy decision as each one of us has our own preferences. Someone will always be disappointed with the choice of colours used in your reports. One way around this is to conduct a survey of the colours to use ...
Read More
/ DAX, Power BI, Power BI, UI/UX

Data storytelling by using the Page Navigation button

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 on a ...
Read More

How to sort a 100% stacked bar chart by % values

By default the 100% stacked bar chart is sorted by the actual value. But that's not very useful as its hard to see what is the top category by %. Fortunately you can achieve the sorting by % value by an easy tip. And it doesn't involve creating calculated columns ...
Read More
/ DAX, Power BI, Power BI, Sorting

Strategic colouring in Power BI – Part 3: Isolating a category in a trend

This is the third post in the Strategic colouring in Power BI series. Links to all the posts can be found here https://www.capstoneanalytics.com.au/master-post-for-strategic-colouring-articles/ In the previous post we saw how to compare a trend of one or multiple category in a field versus the rest of the categories. In this ...
Read More