Forum Discussion

sfaizee's avatar
sfaizee
Helper I
5 years ago

What if parameter value keeps changing single value

HI Everyone, I have created a what-if parameter in my report that takes in a single value (Slicer).  When i open the paramter. It has the below code. (the checked marker) length = GENERATESERI...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

sfaizee , Are you entering the value manually or using slicer. Sometimes with slicer excat value might get selected .

 

I used what with excat values.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • sfaizee's avatar
    sfaizee
    Helper I
    5 years ago

    Hi, 

    I am entering the data manually. 

    The slicer has a scroll bar as well that i have kept open. 

    Even turning it off didnt help. 

     

     

     

     

    • sfaizee's avatar
      sfaizee
      Helper I
      5 years ago

      This the value that i enter manually in the field. 

       

      Entered Manual valueSlicer changed it to this value.Difference
                                    100,00099901                 99
                                    150,000149851              149
                                    200,000199801              199
                                    250,000249751              249
                                    300,000300200            (200)
                                    350,000350150            (150)
                                    400,000400100

                  (100)

       

       

      Slicer values changes. 

      See the difference for you to understand. 

       

      • sfaizee's avatar
        sfaizee
        Helper I
        5 years ago

        Just to clarify the point a bit more. 

        I used a whatif parameter with Data type as whole number

        and DONT SUMMARIZE.

        This created a parameter:

        length = GENERATESERIES(1, 500000)

        and a measure

        Parameter Value = SELECTEDVALUE('length'[Parameter], 100)
         
        Now when i enter the value in the slicer manually. 
        The values change
        Such changes effect the further measures that i have in my report. I am calculating the rates based on length and time. 
        Similarly 3 more what if's in this report. 
        Setup Time = GENERATESERIES(1, 20000, 1)
        Measure 
        Setup Time Value = SELECTEDVALUE('Setup Time'[Setup Time])
        Here are the results of manual entry. 
         
        Thanks for your help. 
        Regards,
        Sahim.