Forum Discussion
Format code for Cards to show in Millions
hi All,
Please suggest format code for Cards to show in Millions.
7 Replies
- Bibiano_Geraldo
Super User
- powerbidev123
Solution Sage
Hi Snagalapur , try this 0.00,, "M"
- Snagalapur
Helper IV
This is not working.
- powerbidev123
Solution Sage
Snagalapur , as grazitti_sapna mentioned in her reply , I didn't replace 0.00 with '#'.
- grazitti_sapna
Super User
hi Snagalapur ,
To format a card visual in Power BI to display values in millions, you can use the following custom
Option 1
format code:#,, "M"
Option 2
select the card visual > Format > Data label > Display unit In this way, we can format our display unit to auto, none, thousand, million,etc.I hope the provided solution works for you
If I have resolved your question, please consider marking my post as a solution. Thank you!
A kudos is always appreciated—it helps acknowledge the effort and keeps the community thriving.- Snagalapur
Helper IV
thank you for suggesting. could you please help on below format for thousand separator
- grazitti_sapna
Super User
Hi Snagalapur ,
To Show in Thousands
#,##0, "K"
I hope the provided solution works for you
If I have resolved your question, please consider marking my post as a solution. Thank you!
A kudos is always appreciated—it helps acknowledge the effort and keeps the community thriving.