Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello Community,
When I use the PBI add-in for Power Point, I am having difficulties choosing a specific visualisation in most cases.
When I activate the add-in I get this screen:
If I select a report from the suggestions in the bottom (where I have blacked out report names), I get a menu where I can filter and select a specific visual. Extremely useful.
If I cannot find my report in the suggestions, the only other option seems to be to locate the PBI report in my browser and copy/paste the url to the report page. The issue is, when copy/pasting the URL I am unable to choose a specific visual and am only able to embed the entire report page.
How can I freely choose from my reports AND get the 'choose one visual' feature?
Edit: after choosing and embedding a specific page I can use 'Focus mode' on a specific visual, but then the visual includes a "back to report" button and a slicer pane. It's not the same clean, slide ready look.
Solved! Go to Solution.
Hi @BIanon ,
You can add any visual to PowerPoint by starting from Power BI Service. If the report has header icons on (the icons that appear in the top right corner of each visual if you hover over the visual), then go to the visual that you want to embed in PowerPoint, click on ... click on Share, then on Open in PowerPoint - there you are, from any report page you have access to.
If you want to get rid of the filter pane, you can turn this on and off in the PowerPoint addin. After you have chosen your tile or report page, an additional "report" icon appears in the footer of the addin that allows you to turn the filter pane on and off:
BR
Martin
Hi @BIanon ,
You can add any visual to PowerPoint by starting from Power BI Service. If the report has header icons on (the icons that appear in the top right corner of each visual if you hover over the visual), then go to the visual that you want to embed in PowerPoint, click on ... click on Share, then on Open in PowerPoint - there you are, from any report page you have access to.
If you want to get rid of the filter pane, you can turn this on and off in the PowerPoint addin. After you have chosen your tile or report page, an additional "report" icon appears in the footer of the addin that allows you to turn the filter pane on and off:
BR
Martin
Hello and thank you for your reply, this was exactly the trick I was looking for even though it still feels like a mistake with the UI from PowerPoint.
Now I can embed any visual which is awesome.
One more question; is there a way to change slicer selections after embedding a visual on a slide?
Yes, absolutely. That's what this AddIn is all about, compared with inserting just an image. The report page is fully interactive and you can use the slicers even during presentation. You can also set filters in PowerPoint and then hide the filter pane - then the filters remain active on this slide.
What is not possible, that is, if you put just one tile (one visual) on the slide and this has slicers applied from the Power BI report page, then you cannot change the slicer afterwards, without going back to Power BI, changing the slicer there, and creating a new slide/AddIn. In this case, I'd rather recommend to create the report in a way that the relevant filters exist in the filter pane, then you can add the visual without filters/slicers applied to PowerPoint and then turn on/off filter pane there to change filters as needed. Or create a report page containing the visual and the slicer and then use this whole report page in PowerPoint.
BR
Martin
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.