cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Grace1
Helper II
Helper II

Sum Column Total of exported data is different to matrix total

Hi

 I have matrix visual when export daa, the matrix total is different from the excel sum column total. 

Appreciate any advice.

 

Thanks

1 ACCEPTED SOLUTION

Hi @Grace1 ,

 

Glad to hear that you have solved your issue,could you pls mark the reply as answered to let more people find the solution.

Thank you.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

View solution in original post

10 REPLIES 10
TarunSharma
Skilled Sharer
Skilled Sharer

Hello @Grace1 
Compare the excel and power bi data or check are you applying any filter on the visuals.

There are filter on the matrix visuals but I not applying it , the filters are set as  ALL currently.

Hi @Grace1 ,

 

Could you pls provide some data with expected output for a test?

It is hard to find a solution just by guessing..

 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Can't provide the confidential data but manage to found the different value which is cause by data problem. Thanks

Hi @Grace1 ,

 

Glad to hear that you have solved your issue,could you pls mark the reply as answered to let more people find the solution.

Thank you.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

aj1973
Community Champion
Community Champion

Hi 

A sample would help the community understand better your issue

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Matrix total different from export data sum totalMatrix total different from export data sum total

Hi @Grace1 ,

 

Based on my test,after exporting data,the matrix table is converted to a normal,row and column category are different,that's why you see different total values:

v-kelly-msft_0-1611025306078.png

You could try "Analyze in Excel":

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

@Grace1 , In case of export of data there limit of no of rows that can eexported. I think that is causing it . You can check the rows in table in power vs in excel 

refer the limit -https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

 

one of the way to get all data is copy paste table from power bi to excel. Refer my video for that - https://www.youtube.com/watch?v=1_XlyzV-PcY

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

The rows in the table matrix  power bi and excel are less than 1000 rows.  Don't think is the limit of no of rows that cause the export different. 

Would not prefer the above method to copy paste table from power bi to excel because
users do not have access to the query editor as the visuals are publish and user can only click on the Export data in the matrix table. 


Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!