Forum Discussion

ahines's avatar
ahines
Icon for Advocate IV rankAdvocate IV
8 years ago

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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.....

ahines's avatar
ahines
Icon for Advocate IV rankAdvocate IV
8 years ago

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.