Forum Discussion
Highlight Blank Value in Matrix Visual
Hi vikramkumawat ,
Thanks Shivu-2000 for the quick reply and solution. Allow me to provide additional insights:
(1)We can create measures.
profits = CALCULATE(SUM(Orders[Profit]),ALLSELECTED(Orders),Orders[Country] in VALUES(Orders[Country]),YEAR(calentar[Date]) in VALUES(calentar[Date].[Year]),MONTH(calentar[Date]) in VALUES(calentar[Date].[MonthNo]))profit color = VAR a = SELECTEDVALUE(calentar[Date].[Month]) RETURN SWITCH(TRUE(), a = "January","red", a = "March","green")(2) Set up conditional formatting.
(3) Manually modify the column width of the Profitt Colo to hide it.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi vikramkumawat
Can you provide me your data or similiar dummy data.
Hi Shivu-2000 ,
Please find the PBIX file in bellow onedrive link:
(https://44g4h0-my.sharepoint.com/:u:/g/personal/vikramkumawat_44g4h0_onmicrosoft_com/EV8ziQQ_DwxKj8WjD7UaXxwBrJUL2UQnA_wJ8LLp0129Rg?e=Vy8VWL) in above file I am able to apply background color to the cells which have any value but for blank cells i am not able to do so, also when I try to fill the blank cells with 0 by adding it to measure it adds extra columns and extra rows in the visual with all value 0.
Please suggest me any possible solution to apply background color to the column if the cell is blank or not.
Thanks!
Hi vikramkumawat
You need to select Cell element -> Background Color -> Rules
This will help you to fill the colors if it is blank.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!