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.
Hi,
i created 2 dimensional matrix table in powerbi , when i trying to export that to excel , it is exported the raw data. Is it possible to get the excel file in the same format as showing in power bi desktop/services( matrix form). Kindly give some solutions.
Solved! Go to Solution.
You can first publish your report to power bi service and then click the ellipse on the right-top hand of the matrix/table visual, then select "Summarized data".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can first publish your report to power bi service and then click the ellipse on the right-top hand of the matrix/table visual, then select "Summarized data".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
after export in excel use pivot table.
If repeating, use macro or Power Query
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |