Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Exporting to excel

when I export to excel it comes with "Applied Filter " on the First row 
I wonder is it possible to edit this "Applied Filter" text or Hide it?

 
 
Need Help
Tips and Tricks

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    If you are exporting data from Power BI to excel with some pre-selected filters, the 1st row exported to excel always has the "Applied Filter...." comment.

    There is no way to remove it.

    You can export everything to excel without pre-selected filter if you don't want this message on top row.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi Anonymous ,

    When you apply filter in a report and export to data, the 'Applied filters' will always show in the first row of excel regardless of summarize data or underlying data. And I'm afraid we cannot edit or hide this 'Applied filter' text unless you delete it manually after exporting to data in excel or export data without applying any filter.

    Also, if you want to make this feature coming sooner, you can submit this idea to https://ideas.powerbi.com/forums/265200-power-bi-ideas to help us improve power bi.

     

    Best Regards,
    Yingjie Li

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