Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have to append 'M' to represent data in "Millions" in a chart visualization. Is it possible to append M in numeric values ?
For eg. my data currently is represented as "1.2" in chart, I need to show it as 1.2M.
Solved! Go to Solution.
Hi @Anonymous ,
On the visuals you can select the options and display units you can have a choice from none into trillions and when you have the several value it will add the M for millions K for thousands,etc.
I believe that the numbers in your data are already in millions so it's only 1.2 correct?
In this case you can use the FORMAT formula to make concatenation of the M but this cannot be used in your chart since it will be a text format.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
On the visuals you can select the options and display units you can have a choice from none into trillions and when you have the several value it will add the M for millions K for thousands,etc.
I believe that the numbers in your data are already in millions so it's only 1.2 correct?
In this case you can use the FORMAT formula to make concatenation of the M but this cannot be used in your chart since it will be a text format.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |