Forum Discussion

ek2112's avatar
ek2112
Advocate II
7 years ago
Solved

Capturing user input data like this one

Hello,   I was wondering how to capture user input, like it did here for "frequent users", "pro users" and "occassional users", to trigger some calculations.    https://community.powerbi.com/t5/D...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    ek2112 you can use the slicer for number field and you will get the same look and feel. just a create table with a columns with the value range you want. for example if you want 1 to 100, there will be a column with 1 to 100 value and you can create this table easily by DAX

     

parry2k's avatar
parry2k
Super User
7 years ago

ek2112 go to modelling table, click data table and enter following DAX command, and you will get Range table with Value column and then you can use Value column in a slicer

 

Range = GENERATESERIES( 1, 100, 1 )
ek2112's avatar
ek2112
Advocate II
7 years ago

parry2k Thank you again! Will try it out.