Forum Discussion

alexa_0028's avatar
alexa_0028
Icon for Resolver II rankResolver II
4 years ago

Conditional formatting based on another measure which should not be present in table

Hi All,

I have implemented conditional formatting for below table based on rules on StatusColor measure.
But the issue is I don't want "Status Color" to appear in my table, I just want to use it for formatting.
I want the result like below but without StatusColor field.

DASX for status color:

StatusColor =
VAR day_type =
CALCULATE (
COUNTROWS ( 'M Calls' ),
FILTER (
'M Calls',
'M Calls'[sk_day_type] in {39,11}
)
)
RETURN
if(max('Calendar'[D. Day of Week])="Saturday",6,if(max('Calendar'[D. Day of Week])="Sunday",7, IF ( day_type >= 1, 8 )))


Rule for conditional formatting:


Can someone pls help me ?

2 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion

    It should be possible.  Can you explain what is not working?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi alexa_0028 ,

     

    You could just remove the "Status Color" from the visual. The conditional formatting on Calls should not be affected.

     

    Best Regards,

    Jay