Forum Discussion
Dynamic slicer values
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.
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 🙂