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

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    marvicf , Try a measure like

     

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

    • marvicf's avatar
      marvicf
      Frequent Visitor
      3 years ago

      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

  • 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