Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi
I have matrix visual when export daa, the matrix total is different from the excel sum column total.
Appreciate any advice.
Thanks
Solved! Go to 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!
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!
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
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:
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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
88 | |
70 | |
66 |