Forum Discussion
Shamatix
5 years agoPost Partisan
Help with Matrix - Nested rows (Examples given along with .pbix file)
Hi fellow Power Bi users. So I'll do my best to explain my issue and the goal I want to achieve. I have also attached a .pbix file in this thread so I hope someone can help me out. So what I...
- 5 years ago
Select these two columns in the query editor, and then click Unpivoted Other Columns.
Data Bar does not support displaying in subtotal or total level at the time being.
You can now apply conditional formatting rules to your totals and subtotals in table and matrix visuals. You will be able to find this new option in the Apply to dropdown in the conditional formatting advanced controls dialog. This feature will work for setting background color, font color, icons, and web URL.
Shamatix
5 years agoPost Partisan
I really cant seem to get that to work, by chance you could show me how in the sample file?
V-lianl-msft
5 years agoCommunity Support
Select these two columns in the query editor, and then click Unpivoted Other Columns.
Data Bar does not support displaying in subtotal or total level at the time being.
You can now apply conditional formatting rules to your totals and subtotals in table and matrix visuals. You will be able to find this new option in the Apply to dropdown in the conditional formatting advanced controls dialog. This feature will work for setting background color, font color, icons, and web URL.