Brisbane, 4000 QLD

+61 4 3836 7017

Blog

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

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