Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Nathaniel
Proud to be a Super User!
Hello @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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |