Forum Discussion
What If Parameter Issue
I've got 2 What if Parameters with formulas "Expense What If = GENERATESERIES(0, 300000, 1)" and "Budget What If = GENERATESERIES(0, 300000, 1)" When I put the "What If Parameter" to "Single Val...
HI parry2k
Oh yeah, it seems the slicer can't cope with that number of rows.
looks like values GENERATESERIES(1, 99998,1) might work or GENERATESERIES (1,300000,3)
Seems to be based on the number or rows.....
Thanks for the responses. None of the above proposed solutions are working. It still is picking a relative value to whatever "single value" I select. I'm not sure why Power Bi put limits on this.
Yeah I came across the same limitation where I added a unicode char what if slicer to my text gantt gallery entry.
I broke it into 2 what if parameters one being in units of 1000
http://community.powerbi.com/t5/Quick-Measures-Gallery/Text-Gantt-Chart/m-p/253466
