DAX generateseries formula using comma instead of dot to separate decimal numbers

[gabrieloli_10]

I would like to customize the DAX generateseries formula to use comma instead of periods to separate decimal places.

Currently I'm using a Segmentation Data Filter to insert a value that is into my generateseries fórmula range (from 0.00 to 5.00).

"2. Variação Venda % = GENERATESERIES(0, 5, 0.01)"

However, in Brazil we don't use dot to separate the decimals, instead we use comma.
I already change the location and language in the settings and the table shows it being separeted by comma.

But when I click in the field to insert a number, it shows as separated by dot. And if I use comma, it dosen't work.

Is there a trick to change it?

[efebent · Accepted solution]

Hi,

If you tried the region settings on the system side and it didn't work, you can try this

VARIATION_TABLE =

ADDCOLUMNS(

    GENERATESERIES(0, 5, 0.01),

    "Formatted Value", FORMAT([Value], "0.00")

)

[Anonymous · Accepted solution]

Hi @gabrieloli_10 

A lot of people seem to have asked that question. This is probably the default behavior for power bi desktop.

If you have tried adjusting the locale but it still hasn't happened. Here I recommend that you do this manually via dax.

Create a column or measure.

Column = '2. Variação Venda %'[Value] * 100 & "," & "00"

Measure = SELECTEDVALUE('2. Variação Venda %'[Value]) * 100 & "," & "00"

Here is the result.

The same type of method:

Solved: Format with dot as thousands separator and comma a... - Microsoft Fabric Community

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[efebent · Accepted solution]

Hi,

If you tried the region settings on the system side and it didn't work, you can try this

VARIATION_TABLE =

ADDCOLUMNS(

    GENERATESERIES(0, 5, 0.01),

    "Formatted Value", FORMAT([Value], "0.00")

)