How to make single whole number selection as a slider

[vilkku]

Hi,

I created a simple list Generate 1 = GENERATESERIES(-12, 12, 1) to get a list of number. I want to user to select one number in easiest way. I notice that a sample report which could make it as a slider for user to select a number. But I don't see that option what so ever.  I notice that the column icon is different. Can anyone help me?

[TomMartens]

Hey,

the Sigma sign indicates that the column has a numeric data type, you can check the data type of a column like so

• marking the column in the fields list
• go to the modeling tab in the menu
  

The other sign indicates that the column has been computed, but doesn't say anything about the data type of the used column.

Regards

Tom

[vilkku]

Hi Tom, your explanation makes total sense. But I have already selected the column format as whole number for data type and format.  I can see that column icon shows SIGMA sign. I still don't have the option for slider. the option to change the slider from list or dropdown to Between doesn't help me.  Any clue how I can hard code the column to be numeric.

 

[Anonymous · Accepted solution]

@vilkku,

Please check if What if parameter returns your expected result.

https://docs.microsoft.com/en-us/power-bi/desktop-what-if


Regards,
Lydia

[vilkku]

It works nicely. Thanks.