format background of matrix field used in row hierarchy

[tamara_nsb]

Hi,  I have a simple table I need displayed but I want to group rows for better readability which I can do in a matrix but I also need to format the background of one of the row headers.  Is this possible?

Example Data

I can do this and color the title yellow when open ( table )

But I would rather have it shown like this with the group name not repeated on every row and groups kept together ( matrix ) but  I can't find a way to format the Title field.

Any Suggestions?   The Group values are dynamic in the real data so I don't think I can group them in the table.

[v-agajavelly]

Hi @tamara_nsb ,

You’re on the right track using the FormattedTitle measure that’s exactly how you unlock conditional formatting in a Matrix, since formatting isn’t possible directly on row headers. The only thing left is to tidy up the visual so it looks like what you want.

Here’s a workaround you can try.
1. Keep your FormattedTitle measure in the Values well.

FormattedTitle =SELECTEDVALUE ( 'Table'[Title] )

    This is what allows background formatting.
2. In the Format pane → Column headers → Turn Off.
That removes the extra header row that was bothering you.
3. Go to Format pane → Row headers → Word wrap → Off.
This keeps your titles in a single line, so the rows won’t stretch out in height.
4. Adjust the column width so the values sit neatly.

Now you’ll have.

• The grouped look of a Matrix (group names not repeated on every row).
• The background formatting applied to your Title field.
• No extra header row showing.

This way you don’t need any messy workarounds, and it will keep working even when your Group values are dynamic.


Regards,
Akhil.

[tamara_nsb]

So I also tried making this measure

FormattedTitle = SELECTEDVALUE('Table'[Title])  and adding it as a value.    But I can't figure out how to get rid of the header row.  If I try to make it narrower to not show it increases the cell height to fit all of the data in the field

[Ashish_Mathur]

Hi,

Turn off wrap text.  This will ensure that when you make the field narrowers, the text does not overflow to the next line.