Forum Discussion
TRADER083
Helper II
4 months agoMatrix row header color different when viewing in workspace
Hi everyone, Here is a before and after of what I see in Desktop vs in Workspace...The row headers somehow inheritted the color from the subtotal...I did select "Apply to labels" for Row level is...
- 4 months ago
try using a fake subtotal , If you really need full control:
- Turn OFF built-in subtotals
- Create a measure that returns subtotal values
- Use:
- ISINSCOPE()
- HASONEVALUE()
Then:
- Add it as a separate row or column
- Apply conditional formatting only to that
This avoids Power BI’s built-in subtotal styling entirely
Accept PBI Service as source of truth
If:
- Your users consume reports in Workspace (not Desktop)
- Prioritize how it looks in Service. Desktop rendering glitches are unfortunately common.
Shravan133
Super User
4 months agotry using a fake subtotal , If you really need full control:
- Turn OFF built-in subtotals
- Create a measure that returns subtotal values
- Use:
- ISINSCOPE()
- HASONEVALUE()
Then:
- Add it as a separate row or column
- Apply conditional formatting only to that
This avoids Power BI’s built-in subtotal styling entirely
Accept PBI Service as source of truth
If:
- Your users consume reports in Workspace (not Desktop)
- Prioritize how it looks in Service. Desktop rendering glitches are unfortunately common.