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: 

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

0
aakashtiwari93

Conditional formatting background color in matrix.

Submitted by on ‎09-10-2023 01:22 AM

Hi everyone.

I have been working in creating a matrix visual, and my client is asking to color rows also as same the values colors.

 

color.PNG

I know we can do coditional formatting to the value section only there no option to apply it the row section.

 

 

values.PNGrow.PNG

 

Is there any way we can color the row values also in the matrix visual?
kindly suggest,

Thanks

Status: Delivered

Hi  @aakashtiwari93 ,

 

There is no direct way to color the row values in the matrix visual in Power BI based on conditional formatting.

It's by design.You can only color the background or font of the cells based on a field value, color scale, rules, or color values.

However, some users have suggested using custom visuals or HTML code to achieve the desired effect.

You can also try to create a measure with your rules that defines the color you want, and then apply conditional formatting to the background or font color based on that measure. 

Color Individual rows in Power BI matrix - Microsoft Fabric Community

 

If you would like to suggest  feature improvements, you may  vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Caitlyn

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎09-10-2023 11:32 PM
Status changed to: Delivered

Hi  @aakashtiwari93 ,

 

There is no direct way to color the row values in the matrix visual in Power BI based on conditional formatting.

It's by design.You can only color the background or font of the cells based on a field value, color scale, rules, or color values.

However, some users have suggested using custom visuals or HTML code to achieve the desired effect.

You can also try to create a measure with your rules that defines the color you want, and then apply conditional formatting to the background or font color based on that measure. 

Color Individual rows in Power BI matrix - Microsoft Fabric Community

 

If you would like to suggest  feature improvements, you may  vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Caitlyn

Idea Statuses