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.
Good, A while ago I've been dragging this problem, but I can't find a solution in any language.
When I add thousands separators to a numeric value it only gives me the first separator from right to left, an example would be something like this:
5,000,000 (As it should be)
5000,000 (As seen)
It only happens with values with 6 or more "zeros" for obvious reasons.
I've already tried to change the regional format and so on, but I can't fix it, it's quite annoying.
Thank you very much in advance!
Solved! Go to Solution.
Hi @OriExil ,
You can try to use custom format strings in Power BI Desktop. More Info: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
I create a column typed as whole number. Like below:
Click the Model View, choose the column and then we select Custom in Format. Steps are shown as below:
We will have three options to choose:
Choose the third one and then delete $:
Result:
If this can't work, you could create a calculated column with FORMAT function:
Column = FORMAT('Table'[Column1],"#,###,###")
Note: FORMAT function returns text values.
Hi @OriExil ,
You can try to use custom format strings in Power BI Desktop. More Info: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
I create a column typed as whole number. Like below:
Click the Model View, choose the column and then we select Custom in Format. Steps are shown as below:
We will have three options to choose:
Choose the third one and then delete $:
Result:
If this can't work, you could create a calculated column with FORMAT function:
Column = FORMAT('Table'[Column1],"#,###,###")
Note: FORMAT function returns text values.
Funciono perfectamente, muchisimas gracias!
@OriExil not sure what is going on, I tried at my end and it works. What is digital grouping setting in your region settings:
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k I have it configured the same way, only I use the dots as thousands separators.
Only on my desktop computer does this happen, on my notebook I have no problems.
Thank you for your time!
@OriExil this is weird, are you using the same version of powerbi on both the computers. I guess you have regional setting in power bi set to default windows settings, correct?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |