Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 48 | |
| 43 | |
| 39 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 63 | |
| 32 | |
| 30 | |
| 23 |