topic Re: Is it possible for field parameters to have dynamic decimal places in DAX Commands and Tips

Is it possible for field parameters to have dynamic decimal places

DAX_pbi_learner — Mon, 02 Dec 2024 19:49:35 GMT

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?

Re: Is it possible for field parameters to have dynamic decimal places

Anonymous — Tue, 03 Dec 2024 01:24:39 GMT

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.

Re: Is it possible for field parameters to have dynamic decimal places

DAX_pbi_learner — Wed, 04 Dec 2024 16:26:23 GMT

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

Re: Is it possible for field parameters to have dynamic decimal places

Anonymous — Thu, 05 Dec 2024 01:24:32 GMT

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