Conditional formatting

[marvicf]

Hi,

I set up a measure to apply conditional formatting to a table visual according to the measure's value

ZoneSelectedWeek = if(ISBLANK(SELECTEDVALUE(Weekly_Extract[WeekNo])),1,2)

The measure works correctly, it's value changes whether week no is selected or not

Now I'm trying to format the background of a column so that if the measure is 1 background is grey or if measure is 2 background is red

My background color format settings

The issue is that no matter what value the measure has the background is always red. Tried also with 0 and 1 for measure values but same result

Any help pls?

Thanks

[Anonymous]

Hi  @marvicf ,

I created some data:

Here are the steps you can follow：

1. Create measure.

ZoneSelectedWeek =
IF(
    HASONEVALUE('TWeekly_Extract'[WeekNo]),1,2)

color =
IF(
    [ZoneSelectedWeek]=1,"grey","red")

2. Format – Background – fx.

3. Go to the Color – Effects interface – [color].

4. Result:

Displayed in Gray when selected:

Displayed in red when not selected:

If you need pbix, please click here.

Conditional formatting.pbix

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[marvicf]

Hi @Anonymous ,

Thanks for your reply.

This works for a card visual but can't get it to work for the background of a table visual column. Column background is set to grey and remains grey whether selected or not

Thanks and regards

[amitchandak]

@marvicf , Try a measure like

ZoneSelectedWeek = if(calculate(isfiltered(Weekly_Extract[WeekNo]), allselected() ),2,1)

[marvicf]

Hi and thanks for your reply

Tried the measure you suggested but still no luck. The measure is working fine as I assigned it to a card visual to see its value and when I select the week it's value changes. The issue is that in the table visual the column background is always the color for value 2 and won't change after that

Thanks