Forum Discussion

marvicf's avatar
marvicf
Frequent Visitor
3 years ago

Conditional formatting

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 measu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    marvicf
    Frequent Visitor
    3 years ago

    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