Matrix Subtotal Highlight

[mussaenda]

I have the matrix table like below photo

Those highlighted in yellow are my row subtotals.

Those in Blue font are my column subtotals.

Is possible to extend my highlight up to the column subtotal that I have encircled?

I tried putting background color to the column subtotal but it highlights the whole column.

Thank you in advance

[santh00]

Hi @mussaenda  did you find the answer for this question

[amitchandak]

@mussaenda , Not sure I got.

But you use conditional formatting on sub total.

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/conditi...

[mussaenda]

Thank you  for this suggestion,

May I know where I can find this feature? On my latest version of Power BI desktop, I cannot find it. Or maybe I don't know where to find.

[v-xuding-msft]

Hi @mussaenda ,

We need to use at least April 2020 version of Power BI Desktop to use it. You could download a latest one from: https://www.microsoft.com/en-us/download/details.aspx?id=58494.

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#totals...

[mussaenda]

Finally, I found it.

Thank you @v-xuding-msft !

But what I wanted to do is only highlight the column total where there is row subtotal.

On the photo I attached before. I have highlighted the whole row subtotal. But the total of the row  subtotal is what I want to highlight only.

Would that be possible?

[v-xuding-msft · Accepted solution]

Hi @mussaenda,

Please try like this:

Measure = 
var a = CALCULATE(SUM('Table'[Sales]),ALLSELECTED('Table'[Segment]))
return
IF([Total Sales] = a,"RED",BLANK())