Editing Power BI slicer values from PowerPoint

Avatar
Written by Julien | Updated

Summary

  1. What is a slicer?
  2. Which slicers values can be edited in PowerPoint with UpSlide?
  3. How to edit my slicers values directly in PowerPoint with UpSlide?

What is a slicer?

Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations. For example a slicer could show you the key outputs (KPIs etc) easily filtered by your relevant categories. For example such as Cities, Months, Client, Brands, Product categories...

2020-08-19_16-23-51.png

For more details on slicer visit this Microsoft article about Power BI slicers

Which slicers values can be edited in PowerPoint with UpSlide?

UpSlide allows you to edit the value of basic single value slicers directly from PowerPoint. The goal is to enable you to duplicate your PowerPoint report from one country to another or for one month to another in a few clicks.

Important
Only the value of a single value filter used as Slicer in Power BI can be edited from PowerPoint. Slicers with multiple values or other filters cannot be edited.

How to edit my slicers values directly in PowerPoint with UpSlide?

Once you have imported your visuals from your Power BI report to your PowerPoint presentation:

  1. In PowerPoint open the Update Links panel
  2. Click on Edit filters button
  3. Edit the name of your slicer by typing it manually then click on the tick symbol
  4. Click on the Apply & Update button

Congratulations! Your report is updated with the relevant data.

2020-08-20_11-29-25.gif

Important
The new value entered manually must exist in Power BI. To avoid breaking the filter pay attention to capitalisation and spaces!