Forum Discussion

inkognito's avatar
inkognito
New Member
6 years ago

Selected Value doesn't work

I've generated a table of numbers from 0-60,000 with an increment of 1.

 

Table = GENERATESERIES( 0, 60000, 1)

 

But when I try and use the selected value function and type in 11,726, it jumps to 11,748, does anyone know why? When I use the slider function it works fine, but is just clunky to try and get a particular number.

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    inkognito - I can confirm this through experimentation and I think I have actually run into this before. It seems that some sort of sampling is going on because there are so many values. That's the only explanation I have for it. You could check the Issues forum here:

    https://community.powerbi.com/t5/Issues/idb-p/Issues

    And if it is not there, then you could post it.

    If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

     

    But, I'm almost certain the reason is the sampling that goes on in visuals when you have too many values to present.