Forum Discussion

gabrieloli_10's avatar
gabrieloli_10
New Member
2 years ago
Solved

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

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?

Tips and Tricks
  • efebent's avatar
    efebent
    2 years ago

    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's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • efebent's avatar
    efebent
    New Member
    2 years ago

    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's avatar
    Anonymous
    Not applicable
    2 years ago

    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.