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.
I am trying to format a number like below.
For e.g; There is a number like 1234567 (This is the result of a Measure)
I am trying to format the above number like 1.234.567
Can anybody knows this please suggest me.
Thanks.
Solved! Go to Solution.
Here is one way to do it. Just use the Substitue part and replace num1 with your measure.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Anonymous
You can use Custom Format in Model view as well.
Here I build a measure returns to 1234567,2345678 like yours.
And select Custom in Format and use this format: #"."###"."###.
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
You can use FORMAT(Table[Column or Measure],"#.###.###") to achieve this.
Note: Whne you use custom format with FORMAT function the numeric value will be converted to String value. Beacuse of which you cannot place this measure on charts but can be used on cards, Table and Matrix.
Regards,
Manikumar
If you find this is helpful, Accept as a solution and Leave a like. 🙂😊
Proud to be a Super User!
Hi @Anonymous
You can use Custom Format in Model view as well.
Here I build a measure returns to 1234567,2345678 like yours.
And select Custom in Format and use this format: #"."###"."###.
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is one way to do it. Just use the Substitue part and replace num1 with your measure.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |