Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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
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.
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