Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Tasha_DGS

Matrix export showing subtotals that have been switched off in visual

Submitted by on ‎11-22-2023 02:52 AM

Hi All,

I have a Matrix report that details volume and value of stock delivered by date / order number and delivery address. In PowerBI.com, this shows exactly the details needed and the row subtotals are switched off but when this is exported to excel it shows the subtotals per date / order number and delivery address so the same values are displayed 3 times. 

I have another report that has subtotals switched off and exports as it should so not sure if this is a bug?

Images below of the report that is not exporting as the visual.

 

Tasha_DGS_0-1700650199281.png

Tasha_DGS_1-1700650293673.png

Thanks

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎11-23-2023 01:34 AM

Hi  @Tasha_DGS 

Have you compared the difference between the 2 reports ? Are you exporting this one on Desktop or on Service?

 

Best Regards,
Community Support Team _ Ailsa Tao

Tasha_DGS
Frequent Visitor
‎11-23-2023 01:48 AM

Hi Ailsa,

Yes, I've had both reports side by side to ensure to make sure I'm setting the same Row Subtotals to the same 'Off' status and both are being exported from .com

The only difference between the 2 reports, is the one that works as it should has 2 rows and the one that doesn't has 3, not sure if that makes a difference?

Tasha_DGS
Frequent Visitor
‎11-23-2023 02:24 AM

Hi Ailsa,

Just an update, I recreated the reported as a table and then coverted it to a matrix and it seems to have solved the problem!

Idea Statuses