Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I currently have a measure that makes a count. and what I wanted was for the thousands to be separated. but the only option that appears to me is to put the comma.
does anyone have any idea how to put a dot instead of the comma?
Best Regards,
JO
Solved! Go to Solution.
Hi,
I create a sample as below:
Then i create a measure to test:
Measure 1 = SUM('Table'[Value])
Then try this measure:
Measure 2 =
VAR t =
SUM ( 'Table'[Value] ) & ""
VAR t1 =
GENERATESERIES ( 1, LEN ( t ) + ROUNDDOWN ( LEN ( t ) / 3, 0 ), 1 )
VAR t2 =
ADDCOLUMNS (
t1,
"Char", IF (
[Value] / 4
= ROUND ( [Value] / 4, 0 ),
".",
MID ( t, LEN ( t ) - [Value] + 1 + ROUNDDOWN ( [Value] / 4, 0 ), 1 )
)
)
VAR result =
CONCATENATEX ( t2, [Char], "", [Value], DESC )
RETURN
result
The result shows:
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
I have found a short version for the measures that works good for me. I prefer using recommended DAX separators but it has its disadvantages such as a comma as a thousand separator. See measure below to solve this issue.
Hi,
I create a sample as below:
Then i create a measure to test:
Measure 1 = SUM('Table'[Value])
Then try this measure:
Measure 2 =
VAR t =
SUM ( 'Table'[Value] ) & ""
VAR t1 =
GENERATESERIES ( 1, LEN ( t ) + ROUNDDOWN ( LEN ( t ) / 3, 0 ), 1 )
VAR t2 =
ADDCOLUMNS (
t1,
"Char", IF (
[Value] / 4
= ROUND ( [Value] / 4, 0 ),
".",
MID ( t, LEN ( t ) - [Value] + 1 + ROUNDDOWN ( [Value] / 4, 0 ), 1 )
)
)
VAR result =
CONCATENATEX ( t2, [Char], "", [Value], DESC )
RETURN
result
The result shows:
Hope this helps.
Best Regards,
Giotto Zhi
Add
Hi @Anonymous ,
I can't use this measure because I'm counting the whole numbers, I don't have decimal places ... it's not a decimal number...
Hi @Anonymous ,
yes i try all the reginal settings, but not work on my side .... that is why i'm look to find a way to this in DAX
Hi @Anonymous
change windows regional setting
And set seperator as dot.
Apply chnages and open pbix file again.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Hi @Anonymous
I think you want decimal as comma seperaor?
Check this,
https://community.powerbi.com/t5/Desktop/Thousand-Separator-and-Decimal-Separator/td-p/194928
one more way is
measure=format([measure1],"##.###")
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Hi @Anonymous , i'm sorry, but no. that is not what i'm looking for....
what I want, is that instead of being separated by a comma(,) it's separated by a dot(.) (it's an integer without decimal places)
Best Regards,
JO
Hi @Anonymous
I have shared one link in last reply have you tried it?
You need to change region setting.
Thanks,
Pravin
Hi @Anonymous , i try a lot of times the reginal settings, but is a dead end.... do you know how can i made this happen in dax ?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |