Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I would like to know how to export data from a matrix report with the different totals ? When I export the data, the .csv file doesn't contain the total and it's a little bit frustrating because I have to keep these totals.
I use a measure for the value area of the matrix therefore the total represent the result of the formula and not the average of each matrix data point. With the .csv file, it is impossible for my colleagues to find the "correct" totals from the data...
Thanks a lot for your answers and sorry for my english...
Solved! Go to Solution.
Hi @aminima,
You could export data to a "xlsx" file in Power BI Service. But it may not be what you want exactly. Maybe you could submit or vote an idea here: enable-total-row-also-to-be-exported
Best Regards!
Dale
Hi @aminima,
You could export data to a "xlsx" file in Power BI Service. But it may not be what you want exactly. Maybe you could submit or vote an idea here: enable-total-row-also-to-be-exported
Best Regards!
Dale
Unfortunately, that would likely require a pivot table type of export from Power BI and the export is not that sophisticated. I wonder if you could come up with a procedure to create a pivot table from the data that is exported and get there that way?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |