Slicer "Select All" option selects more elements than the displayed ones

[bence]

Hi, 

I am having some trouble with the "Select All" option in PowerBI.

I have a slicer to select the projects I want to display. In this context, I want to select projects that have a lower margin than x%, that I can do through measure put in the visual filter of my slicer.

Once applied it does display the correct projects that I want to focus on, but once the "Select All" is selected, it ignores my filter. Thus I have to use CNTRL + click on every project.

Is there a way around this?

 

Thanks

[MFelix]

Hi @bence ,

Using a measure to filter a slicer  is not very practice since has you refer when you do the Select all even the ones that are not showing will be selected and returned in the visualizations.

What is the purpose that you want for this? Do you want to have a card with that calculation only? Or do you want to have a way to select the values and the card/visualization be dependent on the values selected?

[bence]

Hi,

So basically I already have a slicer to select a given date (instead of using TODAY function), so I cannot use calculated columns for my purpose because those are not dynamic with my date.
I am kind of obligated to calculate this margin in a measure.

But once calculated I would love to be able to filter projects that are over/below a certain threshold, so that is why I am trying to use a second slicer to select only these ones.