Forum Discussion

KaySunset's avatar
KaySunset
Icon for Helper II rankHelper II
2 years ago
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...
Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    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

Kaviraj11's avatar
Kaviraj11
Icon for Solution Sage rankSolution Sage
2 years ago

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's avatar
KaySunset
Icon for Helper II rankHelper II
2 years ago

That works well, many thanks 🙂