Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a matrix with 'nested' rows. For example, if you expand the parent category 'Vibrant and accessible heritage, arts and culture' the martix will expand to show the child sub categories: 'No update', 'In Progress' and 'Achieved'.
Is it possible to format the parent (e.g. with bold, coloured text etc.) to make it stand out more from the children? Or use underlines, thicker horizontal lines for the parent lines?
Hi @Fusilier2
When the groups are NOT expanded the colours are controlled by Values, Values Background color
When expanded the colours are controlled by Row subtotals Values Background color
Sadly conditional formatting is not available for Row Headers but you can vote for the idea here:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=df51f072-bcda-ea11-bf22-501ac524580f
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Ah, OK thanks.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |