Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
DAX_pbi_learner
Frequent Visitor

Is it possible for field parameters to have dynamic decimal places

DAX_pbi_learner_0-1733168531937.png

DAX_pbi_learner_1-1733168687192.png

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?

1 ACCEPTED SOLUTION
v-tianyich-msft
Community Support
Community Support

Hi @DAX_pbi_learner ,

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

vtianyichmsft_0-1733188982569.png

vtianyichmsft_1-1733188998868.png

vtianyichmsft_2-1733189014670.png

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.

View solution in original post

3 REPLIES 3
DAX_pbi_learner
Frequent Visitor

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

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

v-tianyich-msft
Community Support
Community Support

Hi @DAX_pbi_learner ,

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

vtianyichmsft_0-1733188982569.png

vtianyichmsft_1-1733188998868.png

vtianyichmsft_2-1733189014670.png

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.