Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am trying to dynamically change the currency symbol according to the currency selection in the slicer.
I am using the FORMAT function to display currency according to the currency selected in slicer
results as:
How to Format it up to 2 decimal places? so the value $1364. should be displayed as $1364.00
Solved! Go to Solution.
@Anonymous , Try like
FORMAT(MeasuretoFormat,"$#,##0.00")
@Anonymous , Try like
FORMAT(MeasuretoFormat,"$#,##0.00")
Hello,
What if I want to format up to one decimal number?
For example. it is now showing like 85.32%
I want to change it to 85.3% using format in dax
Thank you in advance!
= FORMAT(MeasuretoFormat,".#%")
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |