Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
96 | |
90 | |
72 | |
64 | |
58 |
User | Count |
---|---|
148 | |
112 | |
95 | |
81 | |
71 |