Highlighting the subtotal and total in matrix visual

[jostnachs]

Hi all... I have one requirement where i have to highlight subtotal and grand total in matrix visual.  The details are as follows:

I have client code ,clientname,coverage code under rows, month in columns and revenue in values.

the subtotals are at Clientname level and then i have grand total. I am unable to highlight subtotals. I am able to only grnadtotals. the highlight option is not shown when i select the clientname subtotal. Is there a way i can do that?

[vicky_ · Accepted solution]

If by highlighting, you mean to change the colour or something like that - you can use formatting cell elements for that. If you click the fx button, there is an option to apply formatting to the totals only. You create a measure to check if the row is not the grand total 
i.e Highlight Cell = INT(HASONEVALUE(Table[Client Code]))) // note i'm assuming client code is the highest level in the heirarchy

and then you can apply to totals only + set based on the highlight cell measure + if value is 1

[tharunkumarRTK · Accepted solution]

@jostnachs 

Under Row subtotals, if you keep Row level to 'All' then the changes that you apply in values will be applicable to all subtotals. You have another section section called 'Row Grand total' to change the formatting for grand total.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[vicky_ · Accepted solution]

If by highlighting, you mean to change the colour or something like that - you can use formatting cell elements for that. If you click the fx button, there is an option to apply formatting to the totals only. You create a measure to check if the row is not the grand total 
i.e Highlight Cell = INT(HASONEVALUE(Table[Client Code]))) // note i'm assuming client code is the highest level in the heirarchy

and then you can apply to totals only + set based on the highlight cell measure + if value is 1