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 Superstars,
My data lives in a table with metrics in their own column, which has made it awesome for letting users dynamically modify their report views because we have 50 or so metrics. So the base table looks something like this:
ID Category Metric Value
1 A Name Item A
2 A Price 5.20
3 A Quantity 8
4 B Name Item B
etc...
I have the report set up with a matrix visual, with [Category] as a row header and [Metric] set as the column headers, so the users see:
Category Price Name Quantity Other-Metrics-Selected-by-user-with-filters
A 5.20 Item A 8 abc
B 4.50 Item B 6 xyz
With this method though, when a user uses the "export data" function, the extract returns data in the format of my table, with the Metric listed as a column. This is fine for users who know how to use pivot tables, but we have a bunch of people who don't and pretty much need this data to come out with Metrics across columns.
Does anyone have ideas for how I could do this? The only thing I can think of is basically making a copy of the table with all metrics in the new format, but that would lose the dynamic functionality on the report they would be extracting from, plus i think it's unneccessary to have to load the data twice.
Would love some bright ideas! ❤️
Solved! Go to Solution.
Hi @Anonymous ,
Based on my research, it is not supported in Power BI now.
One workaround, you may try File-> Export to PDF instead in Power BI Desktop.
Besides, I found there is a same feature request posted in Power BI Idea forum, you can vote and comment on it: Allow Table and Matrix Data Exports to Match PowerBI Visual.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Based on my research, it is not supported in Power BI now.
One workaround, you may try File-> Export to PDF instead in Power BI Desktop.
Besides, I found there is a same feature request posted in Power BI Idea forum, you can vote and comment on it: Allow Table and Matrix Data Exports to Match PowerBI Visual.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |