How to show only Grand Total instead of showing all sub total for Matrix visual ?

[Dhruvin]

I am using Matrix visual to represent my data.

I want to show only column grand total instead of showing sub totals for all the level of herarchy. In Power BI there is no such option I found to show only Grand total.

 

Any help on it highly appriciated.

[v-juanli-msft]

Hi @Dhruvin

Based on my test, currently it doesn't support to do this in power bi desktop.

You may submit an idea here to improve this feature.

If the "average" added in the "Value" field are columns instead of measures, you could workaround this problem with power query to get the same visual as you expected.

If you are interest in my workaround, i would like to tell more detailed steps.

Best Regards

Maggie