Forum Discussion
Matrix: Conditional formatting on blank cells
Hi All,
Is there any way to apply conditional formatting in Matrix cells where there are no values for intersection?
Currently based on rules, it just applies colors for non zero values.
Thanks for inputs!
5 Replies
- StefanoGrimaldi
Resident Rockstar
yes when you applying a conditional formating theres a option to apply by a measure or value on that selected field, and another option to apply the format to blank values also.
- deodattoNew Member
in your matrix measure values, create a "if" condition for a blank values and with values <> blank, create a varaibles with colors anda aply to condicional filed.
measure =
var blankvalues = "black"
var nonblankvalues = "green"
if(
tableWithValues <> Blank,
nonblankvalues,
blankvalues,
)
you can use this for more option in your condition, like, tableWithvalue >= 2, "red" etc... - AnonymousNot applicable
Hi abpgupta,
You need to confirm these blank parts have corresponded records in your table.
If they mean these records not include in your table, you need to create a category table of the field which not include all values and uses them on your matrix.
Then you can write a measure formula to check the current category and look up raw table records and return specific results for conditional formatting.Regards,
Xiaoxin Sheng- abpgupta
Continued Contributor
Thanks Anonymous! Yes, there is no data for some combination of dimensions and they appear without formatting. Can you please provide a sample about above solution you suggested?
- AnonymousNot applicable
Hi abpgupta,
You can share some dummy data with raw table structure then I can build a sample pbix file based on these data.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng