Forum Discussion
Advocate VDynamic formart
Hi community, I try to find a workaround to apply dynamic formart in hierarchy, For example. The first column, should be apply format to each leven in hierachy, (colof font, font, italic, bold) in a table/matrix visual.
| Country 1 | 425 |
City 1 | 300 |
City 2 | 125 |
| Country 2 | 456 |
I don't find such as configuration, :(.
Any alternative ?
1 Reply
- benibix
Helper III
Hi Peter_23
Use a matrix, and format the two levels in two different cards. In your example Country is the parent row, and Power BI treats a parent row as a subtotal row.
For City, use Format visual › Row headers › Text and set the font style and text color there.
For Country, open Row subtotals. Under Apply settings to, turn on Per row level and pick the Country level. Then in Values set the font style and text color you want, and turn on Apply to labels. Without that toggle only the numbers change, not the Country name.
This is per level, not per value, so every Country looks the same. If you need Country 1 and Country 2 to differ, that isn't covered by these settings.
