Forum Discussion
Matrix Subtotal Highlight
Hi mussaenda,
Please try like this:
Measure = var a = CALCULATE(SUM('Table'[Sales]),ALLSELECTED('Table'[Segment])) return IF([Total Sales] = a,"RED",BLANK())
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:
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?
Hi mussaenda,
Please try like this:
Measure = var a = CALCULATE(SUM('Table'[Sales]),ALLSELECTED('Table'[Segment])) return IF([Total Sales] = a,"RED",BLANK())