Comma Separator

Question

Can anyone help me to change comma separator format from lakhs, crores etc to millions, billions etc. in PBIeg 12,34,56,789 to 123,456,789&nbsp;

ankitpatira · Answer

shrmehta&nbsp;In power bi desktop use different formattig options available under Modelling tab.

shrmehta · Answer

Hi Ankit,&nbsp;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&nbsp;-Shruti

v-micsh-msft · Answer

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 · Answer

Hi&nbsp;v-micsh-msft&nbsp;Here is the data as it is displayed in my reportI 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&nbsp;-Shruti Mehta

v-micsh-msft · Answer

Hi Shruti,&nbsp;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 DesktopRegards&nbsp;

Forum Discussion

Comma Separator

10 Replies

Related content

Drill Through with comma separated values

Comma Separated Values

Decimal separator - point vs comma

Comma for Thousands separator in Card

Comma separated list