cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

matrix visual show total only

I have this requirement to show only total and not sub-totals for a matrix visual. Is there any option or way to do this.

I have multiple values in rows which do the sub-total and then the grand total. I want to hide sub totals and show only Grand total.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: matrix visual show total only

@powerbisach,

 

In the Format section of the Visualizations pane, expand the Subtotals card, turn the Row subtotals slider to On and then Per row level slider.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: matrix visual show total only

@powerbisach,

 

In the Format section of the Visualizations pane, expand the Subtotals card, turn the Row subtotals slider to On and then Per row level slider.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: matrix visual show total only

@v-chuncz-msft Thanks a lot sam...This is just what i was looking for....

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors