Forum Discussion

fuzzyduck's avatar
fuzzyduck
Regular Visitor
5 years ago

Dynamically changing exchage rates

I have a need for the user via a parameter to be able to input an exchange rate and for the report to dynamically recalculate.   It seems the Parameter on a PowerBI report does not like going beyon...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

fuzzyduck , In the column tools, make sure it  4 or 5 decimal place

 

fuzzyduck's avatar
fuzzyduck
Regular Visitor
5 years ago

Altering the decimal places on column tools, does cause the visual to diplay more decimal places, however entering 1.55555 in the parameter results in the number 1.5584, despite the fact I used 0.00001 in the GENERATESERIES function.

Thanks,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi fuzzyduck,

    Yes, I can reproduce this scenario. It seems like the 'single value' mode of slicer not suitable with values with too many decimal places.

    Power bi will try to round the value to the nearest pixel point of the slider bar. If you switch the slicer mode to 'between' or 'before/after', it can work well with inputted values. Perhaps you can try to contact to power bi team to report this scenario.

    Regards,

    Xiaoxin Sheng