cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

chart: "Show as table" no way to export or copy paste that table's data

When a chart is filtered, drilled to the appropriate level and a user right clicks and does "show as table" that feature works great BUT, there does not seem to be anyway to export that table.

 

Copy paste nor an export option.

 

Is there anyway to copy that data in the table?

7 REPLIES 7
Community Support
Community Support

Hi @OneWithQuestion ,

 

Check the Export summarized data feature in Power BI Service.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-summariz...

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

Sadly, using export summarized data does not make any difference.

 

It exports the entire hierarchy, not just the level drilled down to in the report.

@v-jayw-msft...I am facing the same issue as @OneWithQuestion. It would be great if there was separate export function for the "Show data table". Or a way to copy the data from the "Show data table" and be able to paste it into excel. Especially when the "Show data table" isn't the same as the "Summary Export" because of the drill down function.

Super User IV
Super User IV

Do you see three dots on the right top of the table.  Is it not giving an export option?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

The chart itself will have the elipses to show the export options, however, the data table below it (show as table) does not give an export option I am seeing.

 

*If I use the chart's export option, it exports all levels of the chart axis, not just the chart currently as it is displayed and not as the data shows in the "show as table" table.

Hi @OneWithQuestion ,

 

Based on my test, you can export the filtered data after add a filter to the visual.

1 - Copy.PNG2 - Copy.PNG

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

I perhaps did not explain the issue as well as I should have.

 

If the axis has several levels:

 

Year, Month, Date.  Even though we are viewing the Year level, all exports export down to the day level,

So,  instead of 2 years of data as two data points we get 730 rows one per day.  

 

Here is an example of an axis that has just year and month:

Axis has year and month, only year showingAxis has year and month, only year showing

 

Then I select export, and it exports all levels of the axis (in this case only year and month, but if I had day on the axis it would export down to the day level)

export does not match visual's drill down levelexport does not match visual's drill down level

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors