Selecting 2 values with one filter

[Anonymous]

Hi everyone,

My data is filtered by  a Scenarios table

Scenario

1

2

3

4

I need to use a single select filter that when a user filters by 1, I need to filter by 1. When the user filters by 2, it needs to select 1 and 2, when the user selects 3, 1,2 and 3, and so on

Is there an easy way to do this?

I know multi select is available but users find that difficult and forget to do it

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, I can clearly understand your requirement, I think you can achieve this using measure and visual filter, you can follow my steps:

1. Create a table to be placed into the slicer:

Slicer = 'Scenario'

And don’t create a relationship between the two tables:

2. Create a measure in the main table:

Flag =

var _selectedvalue=SELECTEDVALUE(Slicer[Scenario])

return

IF(MAX([Scenario])<=_selectedvalue,1,0)

3. Create a slicer and a table chart and apply a filter to the visual chart like this:

And you can get what you want.

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.