Forum Discussion
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
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:
You can see the export tells me what filters I have applied.
Yeah, I was hoping there was a solution where it could export that value first without the "Applied filters" verbage.
