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 slicer types can be edited in PowerPoint with UpSlide?

You can edit Single Value and Multiple Value slicers using UpSlide directly in PowerPoint when you are updating your exported Power BI visuals. An example time this is useful is when you are duplicating your PowerPoint report from one country to another or for one month to another and can update those filters.

Important
Only single and multiple value slicers can be edited using UpSlide in PowerPoint. Other filters cannot be edited.

How to edit my slicer 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
Tip
If you want to use multiple slicer values type them into the box and separate them using a semicolon ;

Example changing from one month to another (single value slicer)
2020-08-20_11-29-25.gif

Example changing from one store to multiple stores (multi value slicer)
multipe_value.gif
Snag_38d0a84f.png

Important
The new filter(s) you entered must exist in Power BI otherwise the visual will show an error when you update.  Pay attention to match capitalization and spaces!