Forum Discussion
Measures in Matrix with conditional formating
Hi all,
I have the following matrix with a couple of measures. I need to conditionally format the background for each row of the % FOOD COST measure. Existing capabilities allow for conditional formatting of the measure without taking in mind the line.
Any ideas?
Hi Thimios ,
You could refer to the following measure:
Measure = VAR a = SELECTEDVALUE ( Table[CATEGORY] ) VAR b = SELECTEDVALUE ( Table[%FOOD COST] ) VAR if1 = ( a = "BURGER" && b < 0.42 ) || ( a = "CLUB" && b < 0.55 ) || ( a = "HOTDOG" && b < 0.4 ) || ( a = "PIZZA" && b < 0.4 ) VAR if2 = ( a = "BURGER" && b >= 0.42 && b <= 0.44 ) || ( a = "CLUB" && b >= 0.55 && b <= 0.57 ) || ( a = "HOTDOG" && b >= 0.4 && b <= 0.42 ) || ( a = "PIZZA" && b >= 0.4 && B <= 0.42 ) RETURN IF ( if1, "green", IF ( if2, "yellow", "red" ) )Then put this measure into conditional formatting.
6 Replies
Thimios , you have to format all columns row is not possible with same conditions
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesamitchandak To put it in terms of your post, Revenue needs to be formatted per Customer. In my case, Revenue needs to have a different color formatting for every single customer.
Hi Thimios ,
Do you mean to get the following result?
Here is the measure:
Measure = SWITCH ( SELECTEDVALUE ( TestTable[Name] ), "A", "red", "B", "yellow", "C", "green", "D", "gray" )v-eachen-msftI'm afraid not. This is the scenario:
Hi Thimios ,
You could refer to the following measure:
Measure = VAR a = SELECTEDVALUE ( Table[CATEGORY] ) VAR b = SELECTEDVALUE ( Table[%FOOD COST] ) VAR if1 = ( a = "BURGER" && b < 0.42 ) || ( a = "CLUB" && b < 0.55 ) || ( a = "HOTDOG" && b < 0.4 ) || ( a = "PIZZA" && b < 0.4 ) VAR if2 = ( a = "BURGER" && b >= 0.42 && b <= 0.44 ) || ( a = "CLUB" && b >= 0.55 && b <= 0.57 ) || ( a = "HOTDOG" && b >= 0.4 && b <= 0.42 ) || ( a = "PIZZA" && b >= 0.4 && B <= 0.42 ) RETURN IF ( if1, "green", IF ( if2, "yellow", "red" ) )Then put this measure into conditional formatting.
