Brisbane, 4000 QLD

+61 4 3836 7017

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 compare a trend of one or multiple category in a field versus the rest of the categories.

We will use the same dataset as in the previous part for continuity. Define 3 measures as follows

TotalSalesAmount =
SUM ( fctSales[SalesAmount] )

TotalSalesAmountALLSize =
CALCULATE ( [TotalSalesAmount], ALL ( dimProduct[Size] ) )

TotalSalesAmountRest =
[TotalSalesAmountALLSize] – [TotalSalesAmount]

Drag the stacked area chart into the canvas and place MonthName in Axis and  [TotalSalesAmount] and [TotalSalesAmountRest] measures in Values. Change the colour of [TotalSalesAmountRest] to grey and [TotalSalesAmount] to a brighter colour say green or blue

Drag Sizze from DimProduct into a Slicer visual and start interrogating the data.

 

Share this