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.
Hi to All,
I have a figure with decimal places which is displayed like this:
I'd like to change this view to show it like it is but without decimal places. Unfortunatelly when I try to change Format and set decimal places to "0" thousand separator disapears. and have a figure:
Thank you,
B.
Solved! Go to Solution.
hi @bartosz_s,
Then try this formula to create a calculated column ( my table is called Table1 and field Column1):
Column = FORMAT(Table1[Column1],"### ### ##0")
Hope it helps...
Ninter
Hi @bartosz_s,
Did you try the round function?
If not give sample data with expected results.
Ninter
Hi,
unfortunately it doesn't work. ROUND function is not chanhing the way how the numbers are displayed (expected format is xxx yyy zzz. Example 123 456 789). I still have xxxyyyzzz.
Example:
Number: 123 456 789,89 is displayed 123456790 not 123 456 790.
hi @bartosz_s,
Then try this formula to create a calculated column ( my table is called Table1 and field Column1):
Column = FORMAT(Table1[Column1],"### ### ##0")
Hope it helps...
Ninter
Thank you 🙂
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |