Change numbers to display as thousands or milions

[akhaliq7]

I created a table using the enter data option. In that table I added some sales figures. I would like to display those figures as thousands or millions. For example 2.5M how can I achieve this?

[SergioSilvaPT · Accepted solution]

Hi @akhaliq7 ,

You have an option in the Format Visual were you can choose the Display units type:

You can choose Thousands

Or Millions

It formats automatically for you.

Regards,

Sérgio Silva 

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

[headesk]

Not sure if it's an update to power BI but I had to change the series from All to something specific to get the Display units selection to appear. Replying to this incase anyone runs into my issue as this is where I found the initial help.

  

Cheers,

Sean