сonditional formating for subtotals in matrix

Aizhan_S — Wed, 18 Dec 2024 16:44:21 GMT

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.

Re: сonditional formating for subtotals in matrix

Anonymous — Thu, 19 Dec 2024 05:16:11 GMT

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

topic Re: сonditional formating for subtotals in matrix in Developer

сonditional formating for subtotals in matrix

Re: сonditional formating for subtotals in matrix