Measures in Matrix with conditional formating

[Thimios]

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?

[v-eachen-msft]

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"
)

[Thimios]

@v-eachen-msftI'm afraid not. This is the scenario:

[v-eachen-msft · Accepted solution]

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.

[Thimios]

@v-eachen-msftWorks like a charm, thank you!

Great to understand the logic behind that and all possible applications.

[amitchandak]

@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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Thimios]

@amitchandak 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.