Forum Discussion

shrmehta's avatar
shrmehta
Advocate IV
9 years ago

Comma Separator

Can anyone help me to change comma separator format from lakhs, crores etc to millions, billions etc. in PBI eg 12,34,56,789 to 123,456,789 
Need Help
shrmehta's avatar
shrmehta
Advocate IV
9 years ago

Hi Ankit,

 

Thanks for the answer. I tried the modelling tab. I am facing the problem for comma seperator in table. It is correctly displayed in all other visuals

 

-Shruti

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi shrmehta,

Could you please share the screenshot of the wrong format data in table visuals?

I created mine and it displays well.

By the way, it is also available to change the data type under report View (we need to click on the value column first to make the Modeling available), check if it will have any difference when changing the format or data types.

Regards

  • shrmehta's avatar
    shrmehta
    Advocate IV
    9 years ago

    Hi v-micsh-msft

     

    Here is the data as it is displayed in my report

    I checked both data columns and report view and they both display the same formatting. Doesn't change if I change the Data Type from decimal number to whole number

     

    -Shruti Mehta

    • v-micsh-msft's avatar
      v-micsh-msft
      Microsoft Employee
      9 years ago

      Hi Shruti,

       

      Well this seems to be a little werid.

      Hover the mouse cursor at the thousands seperator, would it make any difference regarding the data in table visuals?

      By the way, Microsoft Power BI Desktop now have the October update available, download and install to check if this issue would insist:

      Power BI Desktop

      Regards

       

      • shrmehta's avatar
        shrmehta
        Advocate IV
        9 years ago

        Hi v-micsh-msft

         

        Hovering shows the same format of comma seperator. I updated to October version and the screenshot I shatred was October version.

         

        Regards

  • ShootingBlanks's avatar
    ShootingBlanks
    New Member
    9 years ago

    Hi @Michael_Shao -

     

    Sorry to drudge up this old topic, but I can't find that comma icon anywhere!  Here is what my ribbon bar looks like...

     

    Any ideas???

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      9 years ago

      Your screen shot is from the query editor. The comma icon is on the Modeling tab in data view or report view.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Same issue here , anyone found the answer ? 

         

        Stuck with this : 1,61,350

        Expected output: 161,350

         

        i've tried following

        1. regional settings change
        2. currency change
        3. thousand separate on /off 

        Thank you in advance!

        Vans