Dynamic slicer values

[KaySunset]

Hi everyone,

I am looking for a solution to dynamically enter "from -> to" - values to filter a table. 

In the following screenshot, you can see a very simplified version of what I already got and where it should be going.

The "Cluster" Slicer is using a SWITCH statement to filter the table on the right side in terms of "#OrdersPerCust" (see statement below screenshot).

But instead of the fixed values (<= 1, <=2, etc.) I would like to have it dynamically. I drew a box highlighted with a green error (does not have to look exactly like that) to show what I mean: The empty boxes below "Slicer value from" and "Slicer value to" should allow me to enter e.g. 5 and 10 and then filter the table for all CustomerNames with #Orders between 5 and 10 (here: only Customer D).

Is there any way to make this possible? I have a sample PBIX attached, feel free to play around 🙂

Sample PBIX 

Cluster = CALCULATE ( IF( SUM(Customer[#OrdersPerCust]) = 0 , "0" ,

                                                IF( SUM(Customer[#OrdersPerCust]) <= 1 , "<= 1" ,

                                                IF( SUM(Customer[#OrdersPerCust]) <= 2 , "<= 2" ,

                                                IF( SUM(Customer[#OrdersPerCust]) <= 5 , "<= 5"

                                                , "> 5")))))

BR,

Kathrin

[KaySunset]

Hi @Kaviraj11 ,

that's a great solution for my sample case, many thanks! I will mark it as solution later, but is there any chance you could further assist - unfortunately, I simplified my sample case a little too much 😄 

In my real example, I am trying to filter for decimal values. I have changed the sample file in this regard and cannot get it to work. It seems to be an issue with the relationship on the decimal columns, I feel like it might be an issue with the digits after the comma. I did, however, change format to 2 digits for all columns, and I did round for those measures/columns that I could. 

The slicer still does not work properly, when I try to filter everything between 1 and 2 there should be CustomerName "E" left, but it filters out everything. 

Any ideas? 🙂

New sample file is here: PBIX 

[Kaviraj11 · Accepted solution]

I found out the solution, see the file attached.

I had to change the datatype of #OrdersPerCust to fixed decimal number and modify the expression to generate a parameter to make sure it doesn't go over two decimal values. 

PBIX_DynamicSlicerValues3.pbix

[KaySunset]

That works well, many thanks 🙂

[Kaviraj11]

Also, you can change the measure as below to make sure it doesn't display the rest

CALCULATE(SUM(Customer[#OrdersPerCust]),FILTER(Customer,SUM(Customer[#OrdersPerCust])+0>=SELECTEDVALUE(Parameter[Parameter])))

[Kaviraj11]

Please find attached file with the solutions. 

https://1drv.ms/u/s!AokEm8Ze5L-ogYZ9zZ8u9EetJ9qR9w?e=6VWJ0l 

I have created a parameter, make sure the relationship is created, utilize it in slicer and in the measures created.

Please accept the solution, if it works for you.

Cheers