Spilter/Filter

[tmears]

I wonder if i could pick people brains/skills.  I need to produce a report which i intend to enmbed in a public facing website.  What i am trying to achieve is for users to be able to input a figure which will return results based on calcuations.  the problem i have is that the range of the input is vast ie between 50,000 to 2,000,00 in 5,000 increments.  i thought of using a slider however as you all know this is a greater or less than option, a drop down would produce a massive list which i think is unusable etc etc

Has anyone overcome this problem or have any suggestions.  Any help would be really appriciated 

I hope i have explained myself for you all to understand.

tim 

[MFelix · Accepted solution]

Hi @tmears,

You should use the Parameter table. This will create you a table with an incremental value you want and adding it on a slicer will allow you to make the calculation since the measure is created with the table:

As you can see the New table is created using a formula GENERATESERIES and where you can tweek you parameters if you want to change them in the future.

Regards,

MFelix

[tmears]

thanks @MFelix i will test later but this looks perfect