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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors