Forum Discussion
Solved
How to get the conditional formatting for missing combinations
Hello, I am new to Power BI and would really appreciate your help in solving this issue. I am trying to add conditional formatting to the values in my matrix. The problem is I am unable to g...
Hi nadanur
Power BI cannot apply values - to records that do not exist or to blank entries. A possible workaround is to use separate dimension tables for both row and column categories and assign a value within a measure (usually a zero) when blanks are returned. However, this introduces another issue: it may display values in row/column intersections that should not exist under the current filter context.
Please see the attached pbix.
Hi nadanur ,
We wanted to check if your question has been resolved or if you are still facing any confusion feel free to reach out.
Thank you.