Format numbers in millions

[Snagalapur]

Hi All,

how to format numbers in millions both in table and line chart, Please suggest.

[divyed]

Hello @Snagalapur ,

Thank you @Bibiano_Geraldo , this is indeed helping.

@Snagalapur  - Additionally you can format your dax measure to show in millions and you can use in any visual.

You can modify your measure like below :

Total Sales in Millions =
FORMAT(total_Sales / 1000000, "#,0.0") & " M" 

I hope this helps.

Did I answer your query ? Mark this as solution if this helps, Kudos are appreciated.

Cheers

Linkedin 

[Bibiano_Geraldo · Accepted solution]

Hi @Snagalapur ,

Select your Matrix and got to Format pane, and scroll till specific column and expand it:

Choose the serie you want to format and go to Values-Display units and choose milions:

Now for your line chart, select the line chart, in the format pane, expand Y-Axis, Expand the Values, and in display units choose Millions: