Forum Discussion

astano05's avatar
astano05
Icon for Helper III rankHelper III
4 years ago
Solved

Turn off Applied Filter Section in Exported Table

When exporting a table/matrix from a Power BI report, the export file has the "Applied Filters" section with all filters applied.   Is there a setting to turn this off, so the export does not have ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi astano05 

     

    How did you hide the filters? Based on my test, if I hide a filter in Filter Pane, it will not appear on the visual. It shows "No filters applied" no matter I export data with current layout or export the summarized data. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

"I have hidden filters that the end-user does not need to see" - you may want to rethink that.  It will be better to apply these in Power Query instead.

 

Note that if you allow users to "Analyze in Excel" (as you should) then these hidden filters will be meaningless also.