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.
I have a number of matrices summarizing data for business users; is there a way for the end-user to export the matrix data at the level summarized in the report?
Example:
- Columns are 2017 days, summarized by month
- Rows are Department (level 1) and then Emplyee (level 2)
- Values are hours by employee by day
If an end user tried to export the summary showing top level (depts on rows, months on columns), the summarized export still gives rows that show the daily totals by employee. I know it is a quick pivot to get back to the format, but not all business users can do this.
Tried searching for sometihng in suggestions, but to no avail.
Ideas?
Solved! Go to Solution.
Hi @connork,
Based on my test, by default, export summarized data will export the bottom level summarized data. It is not able to export current level data which we have seen in visual. Maybe you could submit this feature request at ideas page: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Yuliana Gu
For anyone who may have stumbled across this post, I found this idea that you can vote for this functionality to be added.
The problem has not been solved correct? How do i export the report as it currenlty on Power Bi?
Hi @connork,
Based on my test, by default, export summarized data will export the bottom level summarized data. It is not able to export current level data which we have seen in visual. Maybe you could submit this feature request at ideas page: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Yuliana Gu
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.