Forum Discussion
Naveen29
Helper II
Helper IIDAX
I would like to hide measure for colum2 and show total at colum1 level in Matrix. How it possible?
Hi Naveen29
amitchandak Thank you very much for your prompt reply, please allow me to share some content here.
You can do this by creating a measure.
Measure 2 = SUMX( ALL('Table'), 'Table'[Measure] )Create a matrix.
If you don't want blank lines, you can filter through the filters pane.
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserNaveen29 , You have the expand and collapse button in Matrix visual you can use those. Or you can use drill up and drill down
https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Naveen29Helper II
Helper IIamitchandak - I wanted to completely hid the values at column2 and show totals at column 1 level regarless of expand /drill down