Forum Discussion

mathias1998's avatar
mathias1998
Frequent Visitor
3 years ago
Solved

Conditional formating of matrix table with empty cells

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...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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