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.

 

image1.PNG

 

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.

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.

     

3 Replies

  • 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.