Filter that selects multiple filters

[Anonymous]

Hi everyone,

I am trying to create a filter/slicer that is single select and when selected, selects 1 or more filters

Scenario Filter

1

2

3

4

So when 1 is selected it only filters 1, when 2 is selected, it filters 1 and 2, when 3 is selected it filters 1,2 and 3, and when 4 is selected, 1,2,3 and 4

Is there an easy way to do it?

[Jihwan_Kim]

Hi, @Anonymous 

I do not know how your actual data model looks like, but a separate slicer table is needed.

And you can write a measure something like below.

The sample pbix file's link is down below.

Product show =
VAR selectedslicer =
SELECTEDVALUE ( Slicer[Category], MAX ( Slicer[Category] ) )
RETURN
IF (
SELECTEDVALUE ( Data[Category] ) <= selectedslicer,
SELECTEDVALUE ( Data[Product] ),
BLANK ()
)

https://www.dropbox.com/s/b7fra4lhnjx1cdb/rm66.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[Anonymous]

My table looks like this:

So when 4 is selected, I want to select 1-4, makes sense?

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below, and kindly advise whether it suits your case.

Value Total =

VAR selectedslicer =

SELECTEDVALUE ( Slicer[Scenario], MAX ( Slicer[Scenario] ) )

VAR newtable =

FILTER (

SUMMARIZE ( Data, Data[Company], Data[Scenario], "@value", SUM ( Data[Total] ) ),

Data[Scenario] <= selectedslicer

)

RETURN

SUMX ( newtable, [@value] )

https://www.dropbox.com/s/b7fra4lhnjx1cdb/rm66.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/