Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
NJ81858
Helper IV
Helper IV

Filters when exporting

Hello,

 

I have a report that contains a table that is meant to be exported and I am having an issue with the table that is produced when I export the data.

 

Within the Excel table that is exported, at the bottom there is a cell that contains all of the filters that are applied to the visual. Is there any way that I can get rid of this message? I don't want any of my end users to see what filters I have placed on the visual.

 

I also have a title on my visual in the Power BI Service that is not shown when I export my data, other than the name of the Excel File, is there any way to have it be included in the exported Excel File?

 

Thank you in advance!

4 REPLIES 4
djurecicK2
Super User
Super User

You're welcome @NJ81858 . Not sure about a way to include the title of the report.

djurecicK2
Super User
Super User

Hi @NJ81858 ,

 You have to hide each filter individually in the filters pane, then they should not show up in the export.

djurecicK2_0-1674228049650.png

 

@djurecicK2 That worked for the filters, thank you! Is there any way to get the title of the report to show in the exported data or is it simply limited to just in the title?

NJ81858
Helper IV
Helper IV

Here is what the bottom of my Excel export currently looks like, this is the section that I want to get rid of:

Filters Excel.PNG

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.