Forum Discussion
Helper IIMatrix 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 selected as All but the color didn't change in the Desktop version. Is there a way to maintain the white row header and gray subtotals? Ideally, I don't want to conditional format my value columns because headers can't be formatted. Thank you.
Desktop view:
Desktop view
Workspace view
Workspace view
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.
1 Reply
Shravan133Super User
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.