Export data from a bar chart with the current layout

[mikebi]

Hello,

I have a bar chart in my report.

When I make a selection on the table, the bar chart reflects the selection.

However when I export the bar chart the selection is not respected and I get all the values.

How can I get the bar chart to export with the current layout?  This is what my users expect.

Thank You,

Michael

[mikebi · Accepted solution]

Hello,

The best solution is to use a slicer or filter.

Michael

[v-linyulu-msft]

Hi,@mikebi 

If you select a row of data in a table in a service's report, it will only be highlighted in another visualization object, as shown below.

If your requirement is that the user can select the data that he/she wants to select himself/herself, and then export it, the following are several possible solutions:
1.The first, you can select the current page you need to visualize the phenomenon, there are filters on the right column, you can select the data you need in this position:

Then select “Export summarized data” in Export data:

The following are the corresponding export results:

2.Secondly, you can choose to add a slicer in case of editing the view and use the slicer as a user-selected option:

Continue to select “Export summarized data” and the export result is also controlled:

3.Please note that there is a limit to the exported data, so I hope you can check if your data meets the requirements. Here is the documentation, I hope it will help you:

Export data from a Power BI visualization - Power BI | Microsoft Learn

Best Regards,

Leroy Lu

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