Forum Discussion

yakovlol's avatar
yakovlol
Resolver I
3 years ago

Highlight BLANK values in a matrix (Conditional formatting)

Hello! I have a matrix with a hierarchy Product Category - Product -Subproduct

and I have sales by day and weekday (Sunday - Monday).

I need to higlight in yelow blank values only on days Monday - Friday (Saturday and Sunday should stay without changes)

 

I tried this measure

IF (ISBLANK([Total Sales)  && WEEKDAY( MAX( 'Calendar table'[Date] ), 2 ) <= 6,
    "#FFFF00","")

and use conditional formatting for Field values but it doesn't work my blank values are not colored at all.

 

Please help me with this problem 

 

 

Need Help

2 Replies

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

     

    Could you try something like this? So use the gradient rules, but have the gradient be white for all values that aren't empty. And then use the specific colour option for formatting empty values. One downside for this is that you will not get alternating row colours.

    • yakovlol's avatar
      yakovlol
      Resolver I
      3 years ago

      Hello vicky_ Thanks for your answer, I tried it, but this approach doesn't work as it fully needed it also colored the empty values on Saturday and Sunday. But I need that empty values to be colored only on Monday - Friday. So I have two conditions here, the weekday should be Mon-Fri and the values should be empty