Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
107 | |
83 | |
70 |