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.
Inside my report, the user uses a slicer to narrow down to a single specific project. It will then show data related to a single project and evaluate the project status based on a couple of indicators. It appears that when I try to report a number with the SELECTEDVALUE command I do not receive any previous formatting I made in the modeling tab. When I also try to manually apply a conversion inside the DAX I do not get the expected results. The SELECTEDVALUE remains a number. ROUND command works.
What is the proper way to perform this action?
Current Result: Billing was $2229.50 over the actual cost for the past 2 months.
Expected Result: Billing was $$2,229.50 over the actual cost for the past 2 months.
Current DAX Formula:
Measure 1 =
Solved! Go to Solution.
Hi,
Instead of your CURRENCY function, did you try with a FORMAT function ?
FORMAT(myvalue,"$ #,###.00")
Tell us if it works...
Have a nice day
Hi,
Instead of your CURRENCY function, did you try with a FORMAT function ?
FORMAT(myvalue,"$ #,###.00")
Tell us if it works...
Have a nice day
Thank you for your help. It worked and is exactly what I needed.
For Additional information and Options on the format fucntion:
Other use: FORMAT( 12345.67, "Currency")
Link: https://docs.microsoft.com/en-us/dax/pre-defined-numeric-formats-for-the-format-function
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |