The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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