Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Aria89
Helper I
Helper I

Power Bi report embedded in Power Point - Slicer to influence all pages

Hi all, I need to embed some Power Bi visuals into a Power Point presentation. 

Every month I will need to filter so that the data shown are only the data for the specific month. 

I am wondering if there is a way I can put a slicer where I can choose the month I want and then all the visuals in all the pages of the Power Point presentation are influenced to show data for the selected month?

Thanks

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Aria89 
You can use a related date filter/slicer and as a default filter the report to last month.

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

6 REPLIES 6
Ritaf1983
Super User
Super User

Hi @Aria89 
You can use a related date filter/slicer and as a default filter the report to last month.

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thanks a lot for the response. If I do that, will I need to change the filter every month? And if so, will this be reflected to the Power Point report automatically? Thanks! 

No, it always will be the last month.
It was created for dynamic uses like your scenario 🙂

please refer to the linked guides :

https://www.youtube.com/watch?v=pKXIPDhRrbM

https://www.youtube.com/watch?app=desktop&v=jgTmRPiAQP0

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Hello, I am coming back to you for another question on that matter. I have implemented the solution you proposed and it's working fine! I have set up scheduled refreshes for my Power Bi Report which are working great. However, every time I open the Power Point, I need to refresh all the embedded visuals so that the latest data are shown. Is there a way that the embeded visuals in the Power Point are refreshed all together? Or get refreshed automatically?

Thanks!

Hi @Aria89 
If you using "embedded live data " as an export option, you have a refresh button that refreshes all reports' visuals.

Ritaf1983_0-1699541623386.pngRitaf1983_1-1699541678008.png

Unfortunately, there is no way to do it automatically.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Perfect, thank you so much! 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.