cancel
Showing results for 
Search instead for 
Did you mean: 
0

Double totals in matrix preview at right end

Once "total column" in "Format"/"Subtotals" is on, I get two totals at the right end. Do you know how I can fix this?

Capture.PNG

 

 

 

Status: Delivered
Comments
Super Contributor

@sfenerlis

 

It seems that I can only get one total on my side. How about the result if you turn off subtotals for the Matrix Preview visual? Are you using the latest version 2.47.4766.801 (June 2017) of Power BI Desktop?

 

Best Regards,
Herbert

Established Member
Status changed to: Needs Info
 
Occasional Visitor

Hi Herbert, I confirm I have the latest (June) version of the Desktop Client. Also, if I turn off the "Total column" in subtotals" then both columns with totals disappear. Any other ideas?

Super Contributor

@sfenerlis

 

Is it possible to share your PBIX file which can be used to repro to me? You can upload it to online file service like OneDrive and then send the sharing link to me.

 

Best Regards,
Herbert

Occasional Visitor

Dear Herbert. I think I understand the rationale behind the Double totals. It seems that as I drill down to monthly data from yearly, the first sums is supossed to add the monthly data and the second sum is supossed to add data for 2 or more years. If I have monthly data for only one year then Double totals are presented.

I see that the "Grand Total" is available only for columns. Is there a way to insert "Grand Total" on rows?

Super Contributor
Established Member
Status changed to: Delivered
 
Idea Statuses