Brisbane, 4000 QLD

+61 4 3836 7017

Blog

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

Strategic colouring in Power BI – Part 2: Comparing a trend versus the rest

This is the second 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 first post, we discussed how to use strategic colouring to compare different metrics over a common dimension. In this part I will talk about how to ...
Read More

Strategic colouring in Power BI – Part 1: Comparing different metrics across a common dimension

This is the first 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/ So you work in Sales. You want to compare revenue, profit, tax amount over the different business units. You want to see the relative position of a ...
Read More

Analytics use cases for the mining industry – Part 2: Industry Intelligence

Wouldn't it be great if you had access to reliable and accurate mining intelligence data that was not static. Imagine the possibilities of a rich, interactive mining intelligence report that gave you instant insights on your fingertips. This is what the report aims to do. Its a report on Queenslands ...
Read More

Creating horizontal and vertical multiples in a single visual in Power BI

Did you know that is very easy to create horizontal and vertical multiples in a single visual in Power BI ? Watch the video to see how to use the Infographic Designer custom visual to achieve this. Adventureworks dataset was used ...
Read More
Loading...