Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 type in 1 as FX rate, it returns 0.98.
With any other numbers, this parameter is not returning the value I type.
It returns a value close to the value that I typed in.
Any way to fix this problem?
Many thanks,
H
Solved! Go to Solution.
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
Hi hidenseek9,
Does this issue exist all the pbix file or the single one?
From my tests with two Power BI Versions, the what If parameter works well. Here are the pictures of the test result:
Picture1 is tested on the version February 2018
Picture2 is tested on the version January 2018
If your scenario is clicking the number 1, it will appear like this:
For the workaround, you may try to use the Fixed Decimal number, it will return the number you type in.
You could also refer to my test pbix file on OneDrive: https://1drv.ms/u/s!AhDc2ZBZkwhXgQDbIr2uqKlq1kqC
Since I cannot reproduce the same issue on my environment.
If you still cannot fix the issue, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |