Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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())
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
108 | |
88 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |