Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Matrix Header Shading

Submitted by Anonymous on ‎07-01-2019 04:03 PM

I'm trying to apply formatting to the values in my matrix and have it carry to the header.  When it's set up as default, it works fine:

Working.PNG

 

However, if I change the option to "Show on Rows" the formatting goes away:

NotWorking.PNG

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
v-yulgu-msft
Microsoft Employee
Microsoft Employee
‎07-01-2019 11:52 PM

Hi @Anonymous ,

 

Which version of desktop do you use?

 

I was not able to reproduce the same scenario on my side. Version: 2.70.5494.761 64-bit (June 2019).

It looks like not possible to apply background color to headers (measure name).

1.PNG2.PNG

Best regards,

Yuliana Gu

Anonymous
Not applicable
‎07-02-2019 08:41 AM

Hi @v-yulgu-msft

 

I am on the same version.  You have to assign the colors under "Field Formatting" and flip the "Apply to header" toggle to get the shading to change.  The "Show on Rows" option is to move the measure values from columns to rows:

 

Settings to color the header:
FieldFormatting.PNG

 

All works when "Show on Rows" is off ("Revenue" header in purple":

ShowOnRowsOff.PNGShowOnRowsOff.PNG

 

When toggling "Show on Rows" the header shading is gone:

ShowOnRowsOn.PNGNotWorking.PNG

v-yulgu-msft
Microsoft Employee
Microsoft Employee
‎07-03-2019 07:40 PM

Hi @Anonymous ,

 

I have reported this problem internally, CRI: 131280930. Would update here once I get any response.

 

Best regards,

Yuliana Gu

Idea Statuses