Dropdown filter with greater than options

[shyammayhs]

Hi all!

I am trying to achieve something which I can't get my head around!

I would like to have a dropdown filter with values, for example, >5%, >10%, >15%, >20% etc.
Where if I select >5%, it should show all of the values that are greater than 5%. And If I select >15%, it should include all values greater than 15%.

Is this something that is possible to do?

Thanks.

[amitchandak]

@shyammayhs , Create a table like this

Tab= Addcolumns( generateseries(1,100,5) , "Bucket", " > " & format([value], "00") )

then select bucket in slicer

create a measure like

measure =

var _1 = maxx(allselected(Tab), Tab[value])

return

calculate(sum(Table[Value]), filter(Table, Table[Value] >_1/100))

[shyammayhs]

@amitchandak, thanks for your reply.

Could you explain how the measure works? Where should this be applied? what should I be doing the sum of?

Thanks.

[amitchandak]

@shyammayhs ,If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[shyammayhs]

@amitchandak, sure I will put something together and send it over.

But in the meantime, I will try to explain it.

I would basically like the filter to be a column in the table, which would filter other tables in the data model too. The reason why I want it to be a column is that so it can filter the whole dashboard.

[v-easonf-msft]

Hi， @shyammayhs 

One thing to note, currently it‘s difficult to use Dropdown  slicer to filter the values of the entire dashboard, You can only filter reports on the same tile.

Best Regards,
Community Support Team _ Eason