Forum Discussion

Matt22365's avatar
Matt22365
Icon for Resolver III rankResolver III
3 years ago
Solved

Parameter slider not working correctly

Hi all I hope someone can help I have created a currancy exchange rate parameter table to use in a measure to multiply cost values from another table. The measure works great but the parameter vis...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Matt22365 

    Maybe you can refer to the following way

    1.Create the follwing table

    Table = ADDCOLUMNS(GENERATESERIES(0.5, 4, 0.0001),"Round",CONVERT(ROUNDDOWN([Value],4),STRING))

    2.Put the Round field of the table to the slicer, and change the slicer type to "Dropdown" and open the search function

     

    Then create a measure, you can use the measure to calculate

    Measure = ROUNDDOWN(CONVERT(SELECTEDVALUE('Table'[Round]),DOUBLE),4)

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

Matt22365's avatar
Matt22365
Icon for Resolver III rankResolver III
3 years ago

Hi Anonymous 

Thanks for getting back to me

Changing the decimal places has helped as I can now show the 4 I need.

Id prefer to leave it as a single value slider if I can as this will help reduce complexity when the user is choosing an exhange rate. However, I still get the same issue when I type in 1.1732 it changes to 1.1748

maybe a rounding issue? 

1.1732 does exist in the parameter table so im not sure why I cant select it in the slicer

Thanks

Matt 

 

Edit - after a further review it seems the parameter slicer is moving in increments rather than the individual values. e.g. 1.1732 round to 1.1748, 2.2100 moves to 2.1014

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Matt22365 

After testing, when using single value, it will only take numbers that are infinitely close to the entered value, and it is not accurate to the input number, so it is better to use the between type

 

It will only take numbers that are infinitely close to the entered value, and it is not accurate to the input number, so it is better to use the between type

 

 

 

  • Matt22365's avatar
    Matt22365
    Icon for Resolver III rankResolver III
    3 years ago

    Hi Anonymous 

    Thats a shame.

    Unfortunately the between function wont work for me as I am using the selected value in a measure to recalculate some cost values in my table. The measure only works if a single value is selected, even if you make both the between values the same it unfortunately wont work

     

    My Measures:

    SelectedValue = SELECTEDVALUE('parameter table'[parameter],1)

    Cost values = SUM(Costs[Costs])*[UserSelected])

     

    Thanks

    Matt 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Matt22365 

      Maybe you can refer to the following way

      1.Create the follwing table

      Table = ADDCOLUMNS(GENERATESERIES(0.5, 4, 0.0001),"Round",CONVERT(ROUNDDOWN([Value],4),STRING))

      2.Put the Round field of the table to the slicer, and change the slicer type to "Dropdown" and open the search function

       

      Then create a measure, you can use the measure to calculate

      Measure = ROUNDDOWN(CONVERT(SELECTEDVALUE('Table'[Round]),DOUBLE),4)

      Best Regards!

      Yolo Zhu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.