Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slicer from what-if parameter "rounding"

Hi everyone,

 

I have created a what-if parameter and a slicer that's related with that parameter.

 

The code of the table that creates the parameter:

GENERATESERIES(-300000, 300000, 100)
 
Now, if i put 20000 on the slicer it "rounds" to this: 

 

I think it's related to the amount of rows but i can't really know.

 

Does anyone know why the slicer is acting like this? Is it possible to know the maximum amount of rows to display on a table related with a slicer of this kind?

 

Regards,

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    I guess you are using the "Single Value" slicer from the what if paramter:

     

    There the amount of values is limited to 1002 values. You can see that when you take the performance analyzer and copy the DAX query for that visual:

     

    The SAMPLE function is used to limit the amount to 1002 values.

    The chosen values in your area are 19500 and then 20100 again.

     

    To get all the values you want, you would have to change it to a list or dropdown.

    If you change it to a between or less than/greater than slicer, every number between will be available as choice, like 20001 to 20099.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

2 Replies