Exporting hidden visuals to Power Point

Giorgi1989 · ‎03-16-2022

Hi,

In my PBI report, I use buttons to display certain visuals.

More specifically, I have buttons for 'Sales', 'Profits', 'Margins', and 'Countries'.

When you click on 'Sales', it displays a line and stacked column chart showing sales trends over last few years. When you click on 'Profits' it shows the same chart for profits, etc.

What I want to achieve is that users can export all these visuals to Power Point. Currently, when I use the PBI embedded 'export' function, it only exports the chart for the selected button (e.g. "Sales").

Any thoughts on how I could make it possible that all the charts are exported to PPT?

Thank you.

Giorgi1989 · ‎03-29-2022

Apparently this feature is still unsupported by PowerBI as of today. I first submitted a ticket to Microsoft support team to look into this issue, whereafter i was advised by their engineers to submit the idea. You can find the idea here: Microsoft Idea (powerbi.com). Please, vote it up!

v-henryk-mstf · ‎03-21-2022

Hi @Giorgi1989 ,

Select "current value" in the export page, and the exported results will retain the filtered results. Refer to the following.

set in powerbi desktop:

publish to service:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

Giorgi1989 · ‎03-22-2022

Hi Henry,

Thank you for your reply.

No, when I choose 'Current Values' and 'Only Export Current Page", I only get the chart associated with the selected button exported to Power Point.

How have you set up your bookmarks? This is how mine have been set up. I wonder whether there is any causality between these settings and the export results?

Thank you once again!