Forum Discussion
Charli
2 years agoFrequent 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 va...
- 2 years ago
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
audreygerred
2 years agoSuper 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