cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sasas Frequent Visitor
Frequent Visitor

Filtering slicers with report level filters

Hi!

 

Main (problematic) part of my report is slicer which is filtered by report level filters.

Step by step:

- I select value in slicer.

- I change report level filter to filter out selected value.

- Slicer is not changed until I deselect beforehand selected value.

 

Is there any way to filter out selected slicer value?

 

Additional,

If slicer is set to "Single select" and selected value is filtered out I cannot change it to load new data given by the filter change.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filtering slicers with report level filters

hi, @Sasas 

For your case, the best way is use custom visual(from marketplace) instead of built-in slicer.

for example:

5.JPG

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Filtering slicers with report level filters

hi, @Sasas 

For your case, the best way is use custom visual(from marketplace) instead of built-in slicer.

for example:

5.JPG

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sasas Frequent Visitor
Frequent Visitor

Re: Filtering slicers with report level filters

Just for reference, chiclet slicers resolve this issue, but introduce few others.

1) Sort on chiclet slicers isn't consistent

2) They do not have "Select All" option.

3) They load slower than built-in slicer

4) They can't be drop downs, only lists.

 

Just for anyone reading this post to take into consideration.