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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Problem with Syncing Slicers that do not go back to the original state

The slicers are syncing across pages, but after multiple slicings, it stops going back to the original dimensions and filters all pages to a fixed scenario.

 

Example.

- We have 3 slicers: Year, Month and Day.

- They are visible and slicing across all the pages in the report.

 

- Slice as follows: (we are at 13 April 2018)

- Year - 2018 and 2017

-slice Month (all available)- Jan, Feb, Mar

- No slice on Day Review report and build extra pages that sync.

 

Problem

- Unselect month slicers

- Only the 3 previously selected months are available and it doesnt update.

- Unselecting all slicers does not fix this.

 

Result

- Only Months Jan, Feb and Mar Available.

Even after deleting the slicers, the report is still filtered according to the original filter.

I have checked all visuals for their own filters etc.

Its like the report did not forget the slicing.

 

Setup is a live connection to SSAS

using Chrome online

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @ReinhardtScheun,

 

From your description, the issue happens after publish to Power BI service instead of in Power BI desktop, right? 

 

I have tested on my side both in desktop and service but not able to reproduce the issue. Would you please share a small video to show the issue? 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
ReinhardtScheun
Regular Visitor

Hi all,

 

Thank you for trying to help.

 

It seems the issue was casued as follows:

 

  • existing report with the same slicers on each page
  • select a page's slicers and enable them to sync across all the pages (They were already visible)
  • this caused the original slicers on the other pages to go invisible but still be on the page, which meant that they were contradicting the other slicers and thus causing only the limited selection.
  • Solution:
    • Go to each page, view selection pane, make all slicers visible and delete the duplicates

 This was on Power BI Service.