slicer

[Nicki]

Hi 

I need to get a number  in my report by users.

Then  there is a calculated column  based on selected number.

I could not find anything in power BI. Then I use numeric range slicer.

For example, I want to save the value of  12  and it is not the max value for slicer. It can be changed by user.

Thank you in advance.

[Nicki]

Hi 

I need to get a number  in my report by users.

Then  there is a calculated column  based on selected number.

I could not find anything in power BI. Then I use numeric range slicer.

For example, I want to save the value of  12  and it is not the max value for slicer. It can be changed by user.

Thank you in advance.

[parry2k]

you can use whatif parameter and use tht for your calculation, make sure it is used in measure not calculated column.

here is link for info on whatif

[Nicki · Accepted solution]

Thank you parry2k.

It works for me but I need to setup the range number from 1 to 1000.

If you setup the range number from 1 to 10000 It does not work correctly.

[parry2k]

There is an idea about this, vote for it.

Although glad  to hear it worked for you upto some extent.