cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
KyleWilliamsBMI Frequent Visitor
Frequent Visitor

Export Data from Slicer Visual Returning All Results (with filter applied)

Hi Team,

 

A current issue we're seeing with slicers is that you may deselect certain items from a drop-down list. However, when you go to export the data from the slicer visual a dialog pops up that says "Data will export with applied filters", but 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?

 

KW

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Export Data from Slicer Visual Returning All Results (with filter applied)

Hi @KyleWilliamsBMI,

 

I got information below: 

 

This is By Design. Slicers do not filter themselves.  Otherwise, you wouldn’t be able to change the selected value.  Export data does not preserve the current selection on a visual.  If users would like that behavior, please have them file/vote for an item on ideas.powerbi.com.

 

I’d suggest the customer have a table visual next to the slicer.  The table will be filtered by the slicer, so they can do export data from that table.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: Export Data from Slicer Visual Returning All Results (with filter applied)

Hi @KyleWilliamsBMI,

 

The "Data will export with applied filters" message is not specific for the visual which has filtered only. It's just a prompt message, both filtered and un-filtered visual will have this message when exporting data. 

 

I have tested both in Power BI desktop and service, though slicer visual has value selected, exporting data from slicer visual will return all rows. I will contact internally if this is expected behavior. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-qiuyu-msft
Moderator

Re: Export Data from Slicer Visual Returning All Results (with filter applied)

Hi @KyleWilliamsBMI,

 

I got information below: 

 

This is By Design. Slicers do not filter themselves.  Otherwise, you wouldn’t be able to change the selected value.  Export data does not preserve the current selection on a visual.  If users would like that behavior, please have them file/vote for an item on ideas.powerbi.com.

 

I’d suggest the customer have a table visual next to the slicer.  The table will be filtered by the slicer, so they can do export data from that table.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KyleWilliamsBMI Frequent Visitor
Frequent Visitor

Re: Export Data from Slicer Visual Returning All Results (with filter applied)

Thanks, we have submitted this idea at the following link - please vote if you agree this would be a helpful ability!
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34448368--export-data-functionali...