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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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).

22 REPLIES 22

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.

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.