Dynamically changing exchage rates

[fuzzyduck]

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 beyond two decimal places, exchange rates tend to have a lot more precision. Is there any way of increasing the number of decimal places on a parameter?

This rather simple parameter is what I currently have: -

GENERATESERIES(0, 20, 0.01)

But increasing 0.01 to 0.00001 for example has no effect on the captured value in the parameter. The visual for the paraemter rounds it to two decimal places and the stored value is also rounded.

Any suggestions would be appreciated.

Thanks

[amitchandak]

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

[fuzzyduck]

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]

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