user input
1 Topic
Creating measure using user input in Slicer based on What-if Parameter
Hi there, I'm coming from Amazon Quicksight and have been working with Power BI for less than two months only. One requirement we have currently is to provide a slicer for collecting user input (whole number), which will then be used for calculating mesaures. I created a What-if parameter, with range between 0-100,000,000 and increment of 1, and using a slicer out of the same, in single value format, without the slider. Issue is, for small values like 1,000 once I enter the value and hit enter (or even click outside the slicer), the slicer reverts to 0. And when I enter bigger values, it readjusts to some value close to the inut but less than that (eg: If I input 50000, it is changed to 49950). When I reduced the range to something like 10,000 it seems the slicer was accepting more values. But the problem is, the requirement needs the range to be this high. Anybody know why this is happening? And any solution for my requirement? Thank you!Solved