Forum Discussion

deevs's avatar
deevs
Icon for Helper III rankHelper III
6 years ago

what- If parameter User Input rounds off incorrectly

I have created a sequence from 1 to 60,000 using what if parameter ,When you put a value and enter it rounds off in a weird way.(As you know slider is useless in this scenario as you can't really select a desired value when the sequence is too big)

For an example when entered

1 to 31 it changes it back to 1

32 to 91 it changes it back to 61 and so on it was totally random and I am super frustrated.

Slider is useless in this scenario as you don't have the flexibility to select the desired number as the sequence is too big (For example 49249)

Can anyone help me with this issue please ?.

7 Replies

  • deevs afaik it is a known issue and there is a bug reported on issue forum, do put your comments on the issue so that it can be solved. I don't have the link to the post of the issue but you can find it on issue forum here.

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

  • Hello deevs  as you can see, you may have the same problem and include or relate to the power bi forum according to the following links:

     

    https://community.powerbi.com/t5/Issues/bug-What-If-with-decimal-numbers/idc-p/1173208#M58316
    https://community.powerbi.com/t5/Desktop/bug-What-If-with-decimal-numbers/m-p/1158010#M524368

     

    after that I contacted the power bi support and I was answered:

     

    _Hi Afonso,

    Thank you for your time in teams meeting.

    We apologize for the inconvenience caused.

    Summary of the call.

    Issue: What if parameter with decimal numbers not working as expected.

    1.After getting this case, we analyzed from my end.

    2.Raised a high severity ticket to the Product team.

    3.They confirmed that,

    a. The problem comes from the number of values the visual is retrieving.

    b. So if there is more than 1002 different values, some may not be taken.

    c. Anything with more than 1002 values will show the rounding problem.

    d. This visual does not have a hi-density mode that would take more samples.e. It’s an idea to submit to the Ideas web site.

    The Product team will take the priority of the deployment based on the votes polled for the idea. The idea which polled more votes they will take as priority.

    Our Product team pushes improvements and features on weekly basis. These improvements are planned well in advance. But there are some of the improvements which will have lot of dependencies due to which it takes long time and sometimes it becomes extremely hard for us to define an ETA even though we have a road map of improving the feature. We hope you understand the complexity here. Our focus is always on improving customer experience and giving what customer is looking for sooner or later._

     

    basically when you have more than 1002 values ​​the visual cannot behave in the correct format, causing the bug.

    unfortunately, we need a correction as soon as possible, since many companies here in Brazil use this functionality frequently, but until today microsoft has not performed the correction.

     

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    Hi deevs ,

     

    I found that you have an workaround on this problem from another post. Could you share us a pibx template?

     

     

    Best Regards,

    Icey

    • deevs's avatar
      deevs
      Icon for Helper III rankHelper III

      Hi Icey ,

       I will create a template  from my data model and share it tomorrow 🙂

      Thanks,

       

      Deevs

  • rbriga's avatar
    rbriga
    Icon for Impactful Individual rankImpactful Individual

    If you've reached this thread searching for help,

    Power BI now offers a workaround: Fixed decimal numbers.

    Victory!

    This forces the decimal number to remain in the correct form throughout GENERATESERIES()- by using the CURRENCY() function on each value:

    Parameter = GENERATESERIES(CURRENCY(0), CURRENCY(3), CURRENCY(0.01))