Forum Discussion
Formatting based on Parameter
Hello all,
I need to format numeric values based on the user choice of Parameter (dot or comma) and format those values:
Example:
If Parameter dot then 325.12
If Parameter comma the 325,12
Thanks in advance
3 Replies
Try using FORMAT() and IF() If parameter =" ." then FORMAT (325.00) Else FORMAT(325,00).
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielHello Nathaniel_C thanks for the suggestion, but what I'm trying to do is a dynamic way, the 325 was only and example, I want to pass a number type column to DAX and then format it based on the parameter.
Do you have any idea how can that be made?Thanks in advance.
Tiago
Hi TCordeiro ,
Are you doing this in Power Query which uses the M lanquage, or doing this in Power BI using DAX. Would you be able to give us an example? And of output? Where does the parameter come from?
Let us know,
Nathaniel
Please kindly read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
