сonditional formating for subtotals in matrix

[Aizhan_S]

Please tell me how to apply different background colors for the subtotal in a two-level header matrix. For example, level 1 - green, level 2 - yellow.

[Anonymous]

HI, @Aizhan_S 

Thanks for reaching out to the Microsoft fabric community forum.

Could you share your PBIX file with us? This would help us understand whether your data structure supports our solution and allow us to test its effectiveness, especially how your illustrated matrix is constructed and whether it is a custom object.

Regarding your issue, you can try using measures and the ISINSCOPE() or HASONEVALUE() functions to determine if an item belongs to the current level and thus set the color display accordingly.

For more details, please refer to:

ISINSCOPE function (DAX) - DAX | Microsoft Learn
HASONEVALUE function (DAX) - DAX | Microsoft Learn
Hierarchies – DAX Patterns
 

Of course, as mentioned earlier, I am not certain if this solution will address your issue.We recommend uploading it to GitHub and sharing the link with us.When uploading a file, please be careful to delete sensitive information.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu