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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Charli
Frequent Visitor

Formatting specific rows in Matrix

Hello everyone,

 

I have built up an income statement in a Matrix visual and I am now trying to apply some formating on some specific rows.

For exemple, I want the entire line (both measure and value) revenues, gearing etc. to be bold or in a certain color.

I've searched in the format visual section but I was only able to apply the formating on the revenues measure and not the value in front (for example)...

 

Thank you in advance for your help

 

2023-10-31 180926.png

1 ACCEPTED SOLUTION
audreygerred
Super User
Super User

Hello! I would do the following:

  • Create an explicit measure for each item listed in 'Income Statement' field
  • Add each new measure to the matrix
  • Go to formatting for the matrix
  • Expand Row Header
  • Expand Options within Row Headers
  • Toggle the buttom next to 'Switch values to rows instead of columns' to on
  • You can now conditionally format each 'row' since it is it's own measure




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
audreygerred
Super User
Super User

Hello! I would do the following:

  • Create an explicit measure for each item listed in 'Income Statement' field
  • Add each new measure to the matrix
  • Go to formatting for the matrix
  • Expand Row Header
  • Expand Options within Row Headers
  • Toggle the buttom next to 'Switch values to rows instead of columns' to on
  • You can now conditionally format each 'row' since it is it's own measure




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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