Forum Discussion

Shamatix's avatar
Shamatix
Post Partisan
5 years ago
Solved

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...
  • V-lianl-msft's avatar
    V-lianl-msft
    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.

    https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2020-feature-summary/#_Conditional_formatting