Forum Discussion

Nicki's avatar
Nicki
Helper III
8 years ago
Solved

slicer

  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.   ...
Need Help
  • Nicki's avatar
    Nicki
    8 years ago

    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's avatar
parry2k
Super User
8 years ago

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's avatar
    Nicki
    Helper III
    8 years ago

    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's avatar
      parry2k
      Super User
      8 years ago

      There is an idea about this, vote for it.

       

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