Matrix shows one level at a time on the right side of the matrix. How do I see all levels' values?

[HalloWorld]

In a matrix visual, I need to drill down from highest to lowest level to see the values on the right side of the matrix for each node on the left side of the matrix.

How do I show all levels' data in one go?

[HalloWorld · Accepted solution]

You need to switch on the intermediate row sums:

They will show aggregates in bold. You must have a measure that takes the MAX() or MIN(), I always take the MAX(). The value of those upper nodes will not be changed by the aggreagation.

[v-denglli-msft]

Hi @HalloWorld ,

It looks like your problem has been solved.
Please accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .
Thank you very much for your kind cooperation!

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.