Forum Discussion
Conditional formatting of cells
Hi elcamino,
I’ve tested your scenario with sample data on my end. The colour formatting is working correctly only non-zero values are highlighted according to the sale type selected, and zero values are not coloured.
The PBIX file is attached for your reference.
Hope this helps
Thank you.
Super Userelcamino , Try using
Color Code =
VAR SelectedType = SELECTEDVALUE('Sale Type'[Sale Type])
VAR IsAllSelected = ISFILTERED('Sale Type'[Sale Type]) = FALSE || COUNTROWS(VALUES('Sale Type'[Sale Type])) > 1
RETURN
IF(
IsAllSelected,
-- When "All" is selected, determine color based on hierarchical source
IF(
SUM('Sales'[Sales Y]) > SUM('Sales'[Sales X]),
1, -- Blue for Y source
2 -- Red for X source
),
SWITCH(
SelectedType,
"Sales Y", 1, -- Blue
"Sales X", 2, -- Red
"Sales Z",
-- Determine color based on which source is higher/primary
IF(
SUM('Sales'[Sales Y]) > SUM('Sales'[Sales X]),
1, -- Blue if Sales Y is primary
2 -- Red if Sales X is primary
),
0 -- Default/no color
)
)
it doesn't work.
Thanks for the message