How can I use Dax to add blank cells with a coloured background?

[Laxmanjatoth]

I have two queries 
1) How can I use Dax to add blank cells with a coloured background? 
2) how to hide zeros in matrix visuals which is not useful .

[rajendraongole1 · Accepted solution]

Hi @Laxmanjatoth - you can conditionally format a matrix or table visual to achieve the effect of blank cells with colored backgrounds.

create a DAX measure that returns a blank value.

Measure_Blank = BLANK()

add this measure to your matrix or table wherever you want the blank cells to appear.Set the rule for the cells where the DAX measure returns BLANK() or any other specific condition.
Choose a color for those blank cells.

2. You can use a DAX measure that replaces 0 with BLANK()

Measure_HideZero = IF([YourMeasure] = 0, BLANK(), [YourMeasure])

This will display nothing instead of zeros in the matrix.

or You can set rules to format values that are equal to zero. For instance, set the Text color to match the background color for zero values, effectively hiding them.

Hope this helps.

[Laxmanjatoth · Accepted solution]

hello rajendra  basically i tried it , it not working my side  bit requirement different. finally i did it in different way .

[Anonymous · Accepted solution]

Hi @Laxmanjatoth ,

If the problem has been solved, you can accept the answer you found helpful as a solution or share your approach, which will help more people with similar question.

@rajendraongole1 Thank you for your reply and contribution to the community.

Best regards,

Mengmeng Li

[rajendraongole1 · Accepted solution]

Hi @Laxmanjatoth - you can conditionally format a matrix or table visual to achieve the effect of blank cells with colored backgrounds.

create a DAX measure that returns a blank value.

Measure_Blank = BLANK()

add this measure to your matrix or table wherever you want the blank cells to appear.Set the rule for the cells where the DAX measure returns BLANK() or any other specific condition.
Choose a color for those blank cells.

2. You can use a DAX measure that replaces 0 with BLANK()

Measure_HideZero = IF([YourMeasure] = 0, BLANK(), [YourMeasure])

This will display nothing instead of zeros in the matrix.

or You can set rules to format values that are equal to zero. For instance, set the Text color to match the background color for zero values, effectively hiding them.

Hope this helps.

[Laxmanjatoth · Accepted solution]

hello rajendra  basically i tried it , it not working my side  bit requirement different. finally i did it in different way .