What-IF Parameters using decimals

[DuaneDLB]

I enjoy using What-If Parameters. The uers like the ability to play the what-if game with their data, however, I am noticing when I need to create a decimal value it will round up to 2 values to the right of the decimal.   When I click inside the What-if filter it will show many position to the right, but as soon as I click oustide of the filter it will round up my value.  I included several screen shots below to help illustrate my question.  Thanks 

[parry2k · Accepted solution]

@DuaneDLB set the decimal point to 2 on the column tools on the menu

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!

[DuaneDLB]

Thank you for your prompt response but noticed my issue was missing something very important.  I would like for the paramater to default to 3 values to the right. In one of my screen shots I set the selectedvalue '0.345' but when I view my report it still defaults to '0.35'.   

[v-juanli-msft]

Hi @DuaneDLB 

I can reproduce your problem.

Please change the format below and it should work.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DuaneDLB]

Thank you for your response. I should have checked those settings.  I just started using the 'What-if' parameters and assumed when I set the default values it would automatically format the variable.  It's the little things that put a smile on your face.  Thanks again for your help. 🙂 

[parry2k]

@DuaneDLB That's exactly was my very first reply to check the decimal points on format table. Glad it worked out, may be you required screenshots to understand what I was trying to explain 😀

[parry2k]

@DuaneDLB can you make sure the measure also has the 3 decimal points, I tested here and it works:

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!