Forum Discussion
alexa_0028
Resolver II
4 years agoConditional 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:
Rule for conditional formatting:
Can someone pls help me ?
2 Replies
- HotChilli
Community Champion
It should be possible. Can you explain what is not working?
- AnonymousNot 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