Skip to main content
Microsoft Idea

Power BI

Needs Votes

'Export data' functionality from a slicer should only return the values selected

Vote (13) Share
's profile image

on 05 Jun 2018 03:31:42

A current issue we're seeing with slicers is that you may deselect certain items from a slicer, yet all items are returned when you utilize the 'Export Data' functionality from the slicer's header bar. This is especially deceptive, as when you go to export the data from the slicer visual a dialog pops up that says "Data will export with applied filters", yet when the data is actually exported from these slicers the full list is returned. Can this be fixed so that slicers export only the data that is filtered out? Or perhaps an option is included on the 'Export Data" pane which allows the end user to return all values or only those which are selected in the slicer? Thanks!

Comments (3)
's profile image Profile Picture

Power BI User on 05 Jul 2020 23:38:06

RE: 'Export data' functionality from a slicer should only return the values selected

this is an important features please include it

's profile image Profile Picture

Ye Wang on 05 Jul 2020 23:35:03

RE: 'Export data' functionality from a slicer should only return the values selected

This is an important feature to be added. I create one BI report for multiple stakeholders. And they can filter on their suppliers on the slicer and then they can export out to ppt to present to their stakeholders. Without having this feature in place, they have to screen shot each of the tabs in the BI report and paste in the ppt which will be very time consuming. Please add this only export the selected items feature in power bi. Thanks!

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:21:33

RE: 'Export data' functionality from a slicer should only return the values selected

I would like to add that the table returned when 'Show Data' is chosen from a Slicer header should also return only the selected results, not the entire range (unless 'Show All' is selected)