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 = GENERATESERIES(1, 500000)

 
My requirement is to be able to enter an whole number (selected) with an exact length (any number between 1 and 500,000). 
 
The next DAX measure is 
Parameter Value = SELECTEDVALUE('length'[Parameter], 100)
Now, when i enter the value as 300,000; the system changes it to 300,200? Why is it adding 200 i dont understand. 
 
Can you please help me. 
Thanks.

 

Need Help

11 Replies

  • sfaizee's avatar
    sfaizee
    Helper I
    5 years ago

    I could not find the solution to this problem. 

    Any help?!

    • sfaizee's avatar
      sfaizee
      Helper I
      5 years ago

      Does anyone else face the same problem. 

      Any help would be greatly appreaciated. 

      Thanks.

       

  • titaregina's avatar
    titaregina
    Regular Visitor
    3 years ago

    Seems like this issue has not been resolved. Anyone still having the same issue?

  • KiwiFox's avatar
    KiwiFox
    New Member
    3 years ago

    May 2023, still same problem.

    I love how we have to pay for a product that has bugs and then gather enough votes to fix said bugs.. Lovely

  • jstew0809's avatar
    jstew0809
    Frequent Visitor
    1 year ago

    It is 2024 and this issue is still not fixed. What a joke.

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