Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
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