Skip to main content
Microsoft Idea

Power BI

Needs Votes

On matrix table possibility to choose which rows / columns are visible

Vote (8) Share
's profile image

on 16 Jan 2019 18:31:14

Option to choose which value columns / rows are displayed in detail and in total row/column section.

For example columns are product colors and rows are SKUs. Values are for sold pieces and gross margin. I would like to see only sold pieces on detail columns/rows and in total column total gross margin and total sold pieces.

Comments (1)
's profile image Profile Picture

Sean McLarty on 05 Jul 2020 23:39:06

RE: On matrix table possibility to choose which rows / columns are visible

This would help. I have a kpi matrix where I only display columns containing dax measures. I hide an "anchor" column by minimizing its width but there's a risk people can still click on it.