Is it possible for field parameters to have dynamic decimal places

[DAX_pbi_learner]

I have created field parameters for 3 units. However, I want only the Million metric tons to show 4 to 5 decimal places and the other units to be whole numbers. Is there a way to fix this?

[DAX_pbi_learner]

hello, thank you for the solution...do you know how this would work with measures?

[Anonymous]

Hi @DAX_pbi_learner ,

Maybe I didn't understand your need, I created a measure for Value based on the parameter's serial number, isn't that what you want?

Best regards,
Community Support Team_ Scott Chang

[Anonymous · Accepted solution]

Hi @DAX_pbi_learner ,

I made simple samples and you can check the results below:

Replace Value = var _s = SELECTEDVALUE('Parameter'[Parameter Order])
RETURN SWITCH(TRUE(),_s=0,ROUNDUP(MAX('Table'[Category1]),0),
_s=1,ROUNDUP(MAX('Table'[Category2]),0),
_s=2,MAX('Table'[Category3]))

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.