Conditional formating of matrix table with empty cells

[mathias1998]

Hi, 

I have the following matrix table: 

Note that all the cells with zeros are actually empty. I managed to fill them out with zeros by: 

- Adding a +0 to the measure for the count of IDs

- Made three additional tables (Probability, Impact, and Magnitude), which contain all possible levels (e.g., 1-Rare, 2-Unlikely, 3-Moderate and so on) - and made a relationship between these and the table containing the IDs. 

- Clicked "Show Items With No Data" on both Probability and Impact. 

I would like the matrix table to have all the cells filled with colors according to this conditional formating: 

Any help here would be sincerely appreciated 😄 

[Anonymous · Accepted solution]

HI @mathias1998,

It would help you to handle expanded records not really exist in your table if you use custom categories and use them on the matrix. (+0 does not work with expanding records that are not really included in the raw table)
You can use the current row and column values as parameters to look up and calculate values from the raw table.

For the conditional formatting parts, I'd like to suggest you also use DAX formulas to achieve these, these can also work with multiple-level aggregated values.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng