Is there a way to get the list of Filter values export if any user is exporting the data from Visual

[AkankshaRai_123]

Example-
In PowerBI, if our visual includes columns 1 and 2 with slicer filters applied for Age, Gender, and Income, and the end user wishes to export data from the visual, is there a method to also export the list of applied filters along with the visual data?
@Microsoft 

[Anonymous · Accepted solution]

Thank you SaiTejaTalasila and ibarrau, Your solution is great!

Hi, @AkankshaRai_123 

I created a PBIX file using the example data below:

Then you need to turn on the following option in the settings of Power BI desktop:

When the user applies filters, we can export data for individual visual objects and retain the results of the filters:

I've uploaded the PBIX file used this time below.

Best Regards

Jianpeng Li

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

[AkankshaRai_123]

If we apply Multiple filter on the same then the filter description in exported output looks like below

However, can we somehow modify the same filter description in exported output to look as below-

[Anonymous]

Hi, @AkankshaRai_123 

Your original question has been answered, and you can mark a previous helpful response as a solution so that other members of the community can quickly find your post if they have a similar question, saving them time looking for an answer.
For your new request, you can propose the idea on the ideas forum and vote for it, so that the feature will hopefully be launched in the near future.

Home (microsoft.com)
Please mark this response as a solution so that community members can vote for your idea when their case is found.
Your cooperation will help us to promote the development of our community together. Thank you again for your cooperation!

Best Regards

Jianpeng Li

[Anonymous]

Hi, @AkankshaRai_123 

This is the default format and we cannot change it. If you need to change this format, you should change it in Excel.

Best Regards

Jianpeng Li

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

[ibarrau]

Hi. You can't known the filters applied by another user with logs and something like that. However, the person exporting can know. The excel or csv usually shows filters applied, something like:

Applied filters:
Estados is not (Blank)
Mes is agosto
Año is 2024

I hope that helps,

[AkankshaRai_123]

The requirement is, if end user is exporting data from matrix visual, all slicer filters applied on that matrix should also be exported by default ina form of list.
Could you please share PBIX file?

[SaiTejaTalasila]

Hi @AkankshaRai_123 ,

I don't think we have that functionally available.While looking at the exported data they will definitely know what they filtered if they don't have slicer columns available in their data then it will be sometimes difficult to understand what they filtered.

Thanks,

Sai Teja