Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Namkce
Advocate III
Advocate III

Matrix Visual: Format Row Header when Values are as Rows issue

I've noticed a quirk in how Power BI Matrix Visual (doesn't) display Row Headers styling when using Values as Rows:

 

Repro steps:

  1. Create Matrix Visual with columns and values only (no rows)
  2. Under Formating, select Field Formatting and turn on "Apply to header" and make some font/background color changes.

 

Matrix visual: Columns and ValuesMatrix visual: Columns and Values

 

Matrix Formatting: Apply field formatting to headerMatrix Formatting: Apply field formatting to header

 

Observe results:  You will see your formating of that field applied to the column headers, which is as expected.

 

My matrix report when Values are as Column, Headers are formatted.My matrix report when Values are as Column, Headers are formatted.

 

  1. Under Formating, select the Values dropdown and turn on "Show on rows"

 

Matrix Formatting: Values as RowsMatrix Formatting: Values as Rows

 

Observe results:  You will see your formatting of that field not applied to the row headers.

 

I have reports where we want to be able to style some of these rows headers as sections and apparently this is not supported?

 

My Published Matrix report with QuirksMy Published Matrix report with Quirks

 I'm curious to know if there will be a workaround or solution to this.  We would like to have "sections" in our matrix visuals and I thought that I'd be able to apply field formatting to the values and make them as rows would accomplish this, but apparently it does not.  (Note, the reason why the sections are to the far left is because I put special space charaters in those field names in order to "seperate" them out better, but it's not ideal).

23 REPLIES 23

@armand453  As far as I know, I haven't seen a fix yet

 

@v-jiascu-msft Do you know when the fix will be rolled out?  Are you able to provide any status on this issue?

Is there any update on this issue? I've come across it as well and it's quite frustrating. I have a matrix with values on rows, but I can't format the row header to match the field formatting.

 

In my example I have the field formatting for certain rows to have a different background, but I can't get the row header to match.

Anonymous
Not applicable

anno 2022 and still no fix, bummer. This is so essential.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.