Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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
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...
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |