cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
schaetzles
Frequent Visitor

Exporting Data to Excel with multiple visuals and slicers selected

Hello Guys,

I have been struggling with the following issue.

I have to enable a way to export my PowerBI export into a excel while 

multiple slicers and filters are enabled. If possible, via an export button in the report.

The PowerBI report consists of many slicers for the users to choose from 

and one big matrix that containts the data.  While clicking on the matrix and exporting

it to excel works, it is messy und impractical if too many slicers are enabled.

I tried to use Powerautomate as well as the report builder, but that also does not lead to a practical solution.

 

I would be really glad if someone has an idea or solution for this. 

 

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@schaetzles , You can not export multiple visuals to excel as of now. I would suggest you consider analyze in excel. You can add slicers of excel there and save it with values

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@schaetzles , You can not export multiple visuals to excel as of now. I would suggest you consider analyze in excel. You can add slicers of excel there and save it with values

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors