Forum Discussion
Generate Series input value
Hi Expert
I have a strange situation
Generate a series
You have fallen victim to the sampling monster.
Nothing you can do about it - except for using (much) smaller ranges or larger interval steps.
14 Replies
Hi, of course
see the pbix attached in the drive
https://drive.google.com/file/d/1Xi7LbWOd6TepN0MGjhMffLbHoRHi9M26/view?usp=sharing
Try to put the value 1000 in the input
Thanks a lot, Fernando
Hello, I know this post is a little older but today a customer of mine had the same issue and I come up with a work around, which may help others as well.
The problem is not with value generating, but with Slicer using Selected value selection.
You can change it to different Options - Style, like Greater then or equal to
Then adjust the measure which was generated to use MIN(), instead of SELECTEDVALUE()
Slicer will now contain 2 boxes, where 1 is showing maximal value you can chose.
You can then play with formatting, or overlay 2nd box with white rectangle to hide it.
Please mark my post as a solution in case it helped.BR
Martin
worked as a charm, kudos 🌋
I was struggeling with this for a few days already, thank you so much! This works perfect
How is the GENERATESERIES table related to the user input? Did you create some "What if?" parameter?
Hi!
First created manually the same "what if" parameter structure, and then try create a What if parameter, but using the what if parameter have the same problem
the result is a "table" with this two fields:
1)List of values result with the generate series
2) field that get the value:
Value = SELECTEDVALUE('Table'[listavalue])Thanks!That sounds correct. Would you be able to post a sample pbix file?
You have fallen victim to the sampling monster.
Nothing you can do about it - except for using (much) smaller ranges or larger interval steps.
You still see the "I" warning even with 1000 at step 1
Change the step to 5
It's not a bug, it's a feature. Seriously - there is no way the visual can cram 1000 data points onto your screen. Not enough pixels.
Hi Anonymous ,
I found a similar thread which may explain the strange senario:
The reason why some of the numbers don't appear and revert back to another number when entered is due to PBI sampling the data, the range that you are using is to big.
When you set a large range using GENERATESERIES,and when you select the number which is ranking over 1000*increment ,it will be sampled.As you tested before,the workaround to solve it is to choose a bigger increment,for example,in your senario,you set a series from 1 to 10000 with an increment 1,and you select 1000,which is ranking 1000,that's why you get a result of 999,which is a sampled result.
See:
When you change the increment to any value bigger than 1(should be an integer,decimal situation would be more complex),which will ensure that the selected value is below the ranking of 1000,and you will get the expected result:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
keep doing what you are doing - that's what the "what-if" feature is for.
Use the "Between Slicer" and have the same value in both boxes.
