Forum Discussion
Matrix Subtotal Highlight
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
Hi mussaenda,
Please try like this:
Measure = var a = CALCULATE(SUM('Table'[Sales]),ALLSELECTED('Table'[Segment])) return IF([Total Sales] = a,"RED",BLANK())
6 Replies
mussaenda , Not sure I got.
But you use conditional formatting on sub total.
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.
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:
