Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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 , 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")
Many thanks!
Will try asap and let you know
Best
Hiero