Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago

Power BI Tricky query

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

3 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    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