Forum Discussion

Smackcat's avatar
Smackcat
Icon for Helper I rankHelper I
3 years ago
Solved

Selectedvalue in calculated column to generate numeric ranges

Hi experts! I ideally would like an user inputbox, but as it's not available on PowerBI, I'm using an slicer for the user to select a unique value. With this selected value, I would like to create numeric ranges.

 

I have an "Income" column. I want the user to select a "Number", with this number I want to create ranges "From XX to YY" according to the selected value on "Number" (the range is constructed from multiples of "Number": "From 1 to 29", "From 30 to 59", and so on...).

To get this "Number" value I have created on another table a list of numbers to get an slicer that allows the user to select a unique value. I had no issue at creating this sequential table (that's not my question)

I want to connect this unique selected value from the slicer to the "Number" column, but I think it's impossible to use SELECTEDVALUE on a calculated column, because the result is a blank column:

 

So my question is: is there a way I can create numeric ranges according to an user selected value on this slicer? is this even possible? is there a meassure at least I can use to get these numeric ranges? 

 

Thanks

 

3 Replies