Power BI Tricky query

[vjnvinod]

Hi Team,

below is one of my visual.

i would like this numbers to show in thousands.

for eg number 16,70,00,000 should be shown as 16,70,00

and also when my user export this to excel, they should see the actual number, which is 16,70,00,000

how do i achieve this?

below is one of my visula

[v-danhe-msft]

Hi @vjnvinod ,

Based on my research, I am afraid you could not achieve this feature currently, you could change the unit in the formatting, it will show 167000K:

Regards,

Daniel He

[vjnvinod]

@v-danhe-msft 

Can you please request this feature to be added?

for now is there any workaround, i can do? to remove "K" and show the full string attached to the numbers in the excel

[v-danhe-msft]

Hi @vjnvinod ,

Sorry, I have no access to add this feature for you, I suggest you could submit an idea in ideas forum that may help you solve your problem:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He