Forum Discussion

Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper IV
1 year ago
Solved

Format numbers in millions

Hi All, how to format numbers in millions both in table and line chart, Please suggest.      
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    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:

     

     

divyed's avatar
divyed
Icon for Super User rankSuper User
1 year ago

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