Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |