Result of SWITCH being an IF function not working in conditional formatting of Table Visual

[Anonymous]

Hello,

I have a measure which shades cells in a table visual based on the month, and the ranking of those months to show a subscription length.

For this particular instance, I want to shade one of the rows differently because it has a different subscription rollover month.

I have tried to select this particular customer by a number of fields but none seem to return the expected result, just the result of the condtion not being met.

 I would like the second row to be only shaded to september. But it never is able to pick up the first condition. 

The measure returns the shading colour and is applied via field value in conditional formatting.

Any help with this is greatly appreciated.

Thanks.

[amitchandak]

@Anonymous , True Switch True

Switch(True(),

Selectedvalue(Agent[Agent id]) = 122 && [Product Rank] <=2, "Light Blue",

Selectedvalue(Agent[Agent id]) = 122 && [Product Rank] <=4, "Drak Blue",

"White"

)

[Anonymous]

Hi @amitchandak, 

The conditional statements are deciding how many cells to shade, not necesarily what colour. Product rank ranks the months decending so "if(productrank <= 2)" will shade the last two months (Oct, Sep). 

I am trying to nest the IF function inside the Switch function so that the RESULT and the ELSE result are IF functions.

Is this possible to do inside condtional formating? I am assuming it would require for the conditional formatting to be evaluated for every line.