Apply different background colors to different row subtotals in matrix visual

[Hierophant]

Hi to all. I am new here so any help would be highly appreciated.

I have a matrix in Power BI Desktop showing global car sales. It has 4 rows:

- Region (US, Europe, Asia, . etc),

- Car Manufacturer (e.g. Toyota, Ford, BMW, etc) ,

- Model (e.g Corolla, C-Max, etc) and

- Engine (cc)

It has 2 value columns:

- Items sold

- total Sales (USD)

My question is:

is it possible to set a different background color for each row subtotal, eg blue for each region, green for each car makers and yellow for each model? Or even set different font sizes?

A simplified, mock example is given below.

It appears that you can't set custom formatting  per row subtotal. Is this true?

Thank you very much in advance!

[amitchandak · Accepted solution]

@Hierophant , The best you can have is color for values different for different for different levels.
Create a measure like the below, and use that in conditional formatting-> Field Value -> Values and Total and choose a measure. Do for all value fields

You can use column from you visual, use in order last level to top level

Color Based on total = Switch( TRUE(),
ISINSCOPE('Item'[Category]), BLANK(),
ISINSCOPE('Item'[Brand]), "Blue",
ISINSCOPE('Date'[Month Year]), "Green","Yellow")

[Hierophant]

Many thanks!

Will try asap and let you know

Best

Hiero