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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
EaglesTony
Post Prodigy
Post Prodigy

How can I export table values with a slicer value ?

I have a table based off a slicer.

 

For Example, my slicer has Version1, Version 2, etc and based on the user selection the table is filtered.

 

What I want to do is export the table contents into excel with the slicer value as well.

 

For example if I have the following:

 

SLICER VALUE: Version 2

TABLE:

Item1

Item2

Item5

 

When I export the table, I want to have

Item1  Version2

Item2  Version2

Item5  Version2

 

Ultimately, I would want the first row exported to be the slicer value and then the table, so in excel it would something like:

 

A1: Version2

A2: Item1

A3: Item2

A4: Item5

2 REPLIES 2
audreygerred
Super User
Super User

When you export from Power BI service the filters applied will be in the export - they aren't in the first row though. Here is an example:

audreygerred_0-1706113574151.pngaudreygerred_1-1706113602788.png

You can see the export tells me what filters I have applied.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Yeah, I was hoping there was a solution where it could export that value first without the "Applied filters" verbage.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.