Forum Discussion
Solved
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 a...
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.
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])))