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