cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
abloor Regular Visitor
Regular Visitor

See multiple slicer selections in PPT/PDF export

Hi,

 

When I export my PBI report from the service to a PPT, I can't see what selections have been chosen in the drop down slicers.  It just says 'Multiple selections'.  

I don't want to change it from drop down slicer to List as there are lots of slicers and limited room.

 

Can anyone please suggest a way to make all the slicer selections visible when the report is exported?  The managers that use my reports are getting annoyed with having to create a text box for each page and type in there what was chosen in all the slicers. Smiley Tongue

 

I had an idea to use a Multi-row card that contains the same field as each slicer, and tuck them at the bottom of the page and use a small font.  Or a normal card with DAX that contains all selected values as per this page. These ideas still take a lot of room though.

 

Any ideas to get this info on the page without taking a lot of room would be appreciated.

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: See multiple slicer selections in PPT/PDF export

Hey,

 

unfortunately there is nothing like a visual that adjusts its dimensions to the number of elements selected. For this we have to treat the available screen estate very carefully, maybe this might be a good idea: a combination of a "fly-out slicer panel" (described in this article: https://exceleratorbi.com.au/create-a-power-bi-slicer-panel/ by @MattAllington ),  combined with this measure here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Title/td-p/196974 by @Phil_Seamark 

 

Another approach could be to use the Smart Filter visual that you can find here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Title/td-p/196974

 

Hopefully this provides you with some ideas.

 

Regards,

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Super User
Super User

Re: See multiple slicer selections in PPT/PDF export

Hey,

 

unfortunately there is nothing like a visual that adjusts its dimensions to the number of elements selected. For this we have to treat the available screen estate very carefully, maybe this might be a good idea: a combination of a "fly-out slicer panel" (described in this article: https://exceleratorbi.com.au/create-a-power-bi-slicer-panel/ by @MattAllington ),  combined with this measure here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Title/td-p/196974 by @Phil_Seamark 

 

Another approach could be to use the Smart Filter visual that you can find here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Title/td-p/196974

 

Hopefully this provides you with some ideas.

 

Regards,

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

abloor Regular Visitor
Regular Visitor

Re: See multiple slicer selections in PPT/PDF export

Thanks for the great ideas @TomMartens .

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 414 members 3,743 guests
Please welcome our newest community members: