Forum Discussion

hidenseek9's avatar
hidenseek9
Post Patron
8 years ago
Solved

what if parameter

Hello Power BI Community,   I am using What if Parameter to calculate price in different currency.     Basically, I am creating a parameter just like below.     However, when I ty...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi hidenseek9，

     

    By confirmed by PG, the cause of this issue is that your parameter range is too big. We have a fix that will allow up to 3500 (or maybe even 5000 if perf looks good). Should land in a couple of months. 

     

    Best Regards,

    Cherry  

hidenseek9's avatar
hidenseek9
Post Patron
8 years ago

v-piga-msft

 

Thank you for your response.

Yes it happens with all pbix files unfortunately.

 

It also happens with your test pbix file as well.

When I select 1.5, it returns 1.4 and when I select 120.8, it returns 120.7.

 

This means it may not be the problem with just my pbix file,

but a bug at Power BI level??

 

 

Many thanks,

 

H

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi hidenseek9，

 

By confirmed by PG, the cause of this issue is that your parameter range is too big. We have a fix that will allow up to 3500 (or maybe even 5000 if perf looks good). Should land in a couple of months. 

 

Best Regards,

Cherry  

  • hidenseek9's avatar
    hidenseek9
    Post Patron
    8 years ago

    v-piga-msft

     

    Cherry, thank you for this.

    I will shorten my range.

     

    Thanks,

     

    H

  • arielt's avatar
    arielt
    Regular Visitor
    8 years ago

    Hi Cherry

    the customer should be aware of the limits.

    my one, for example, is trying to use a parameter that spans from 1 to 100k (step 50), 2000 effective values,  and it doesn't work as expected.

     

    the limit is 1000, 3000, 15k or what? can we get any documentation?

     

    thanks

    Ariel