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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Power BI Report Server Matrix Visual: Format Row Header when Values are as Rows issue

Hi,

 

Cannot format row headers when values are as row in Matrix visual on Power BI report server

 

Regards,

Maddy

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

Which "values" did you mean? The measure can't be dragged to Rows bucket of the matrix visual. 

 

As we can't edit the report in Power BI report server web portal directly, to format row headers of the matrix, we need to open the report in Power BI desktop optimized for report server to modify settings. 

 

q1.PNGq2.PNG

 

Reference: 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable

Hi @v-qiuyu-msft ,

 

Thank you for replying to my post.

 

Yes i can format all row headers as you have mentioned above.

 

Problem is when values -> show on rows is on I cannot conditional format row header colors. Even though Apply to header is turned on it does not make any effect

 

 Capture.PNG

 

Capture2.PNG

 

Regards,

Maddy

v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

It should be the same issue as this thread: https://community.powerbi.com/t5/Issues/Matrix-Header-Shading/idi-p/728981. Currently there is no ETA. 

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable

Hi @v-qiuyu-msft ,

 

Yes. Hope you will give the solution soon. We expect this funtionaly as a basic formatting option in Power BI

 

Regards,

Maddy

Anonymous
Not applicable

Have they fixed this issue in jan 2020 version? 🤔

 

Regards,

Maddy