Forum Discussion

amrshll123's avatar
amrshll123
Regular Visitor
1 year ago
Solved

GENERATESERIES() Excluding certain values

All, 

I created a parameter table using the GENERATESERIES function as such: 

GENERATESERIES(-1, 1.0001, 0.0001)
I use these values in a single value slicer to add a difference to a number. However, I noticed that certain values are completely exluded from the series. For example: 0.1260: 


The value is just not there at all. The negative version is there, -0.1260, but not positive 0.1260. Does anyone know why this may be occuring?

 

Thanks in advance. 

Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Your parameter can have a maximum of 1000 discrete values. Your step resolution is too fine, resulting in sampling.

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Your parameter can have a maximum of 1000 discrete values. Your step resolution is too fine, resulting in sampling.

  • amrshll123's avatar
    amrshll123
    Regular Visitor
    1 year ago

    Is there a way to get a parameter table without that resolution issue? I tried to hardcode values from an excel but then you lose the ability to create a single value slicer.

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      No, there is not.  And think about it from an end user perspective.  No user will want to scroll through 10000 values.

       

      If you want to allow the user to enter their own values use the Filter Pane.