Forum Discussion

Mdived's avatar
Mdived
Frequent Visitor
1 year ago
Solved

Number Format not changing in Power BI

Hi Team, I am preparing the report with simple chart with month number with reporting value. I have filed / measure called Reporting value. And, i would like to show the value in Million. Ex: If v...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    Mdived Try: 

    FORMAT( [Column1], "###,###,###", "en-US" )
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Mdived ,

     

    Your solution is great, Greg_Deckler . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference. 

     

    You can separate the numbers in table view by selecting the columns you want to change and clicking on the commas in the COLUMN TOOLS.

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Mdived ,

 

Your solution is great, Greg_Deckler . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference. 

 

You can separate the numbers in table view by selecting the columns you want to change and clicking on the commas in the COLUMN TOOLS.

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.