Brisbane, 4000 QLD

+61 4 3836 7017

Blog

Strategic colouring in Power BI-Part 8: Transforming a stacked column chart to highlight individual series

This is the eighth 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/ Stacked column charts are hard to visualise especially when you have more than four "stacks" and if one of them predominates its harder to visualise even with ...
Read More

Using DAX to prevent users from entering the detailed pages from a landing page until every slicer is selected

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 conditional ...
Read More

Strategic colouring in Power BI-Part 7: Dynamically plotting yearly percentage sales of top N products and measuring against a dynamic target

This is the seventh 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 sixth post, we discussed how to isolate and visualise YTD data In this post we will discuss how to dynamically calculate the yearly percentage sales ...
Read More

Strategic colouring in Power BI – Part 6: Visually showcasing the years in which a selected product is the top product

This is the sixth 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 fifth post, we showcased how to visually determine the difference in sales from a base year for different segments In this instalment we will discuss ...
Read More

Master post for strategic colouring articles

This is a master post which contains all the links to strategic colouring articles. This post will be updated as new articles focusing on strategic colouring are posted. Link to github repo containing all the Power BI files also included in the end Part 1 - https://www.capstoneanalytics.com.au/strategic-colouring-in-power-bi-part-1-comparing-different-metrics-across-a-common-dimension/ Part 2 - ...
Read More

Strategic colouring in Power BI – Part 5: Difference in sales from a base year for different segments

This is the fifth 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 fourth post, we discussed how to isolate and visualise YTD data In this post we will discuss how to visualise differences in sales for various ...
Read More