Forum Discussion
Parameter slider not working correctly
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.
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
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
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.