Forum Discussion
Dynamic slicer values
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 🙂
BR,
Kathrin
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.
5 Replies
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
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])))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
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.
That works well, many thanks 🙂
