Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can someone please help me format Rand amounts and use proper thousand seperators - for example R 5,600,120,
Solved! Go to Solution.
Hi Tvukeya,
Going to the data table choose the column that your are getting the Total Receipting amount from and click to format the column with a comma ",":
When you are in the actual visualization options under the paint brush make the display as "None" so it resolves as the format you chose with the comma.
I hope this helps! Good luck,
Christian
Hi @tvukeya,
Based on your description, you want to format your number to be South African rand format, in this case, you can click your column in the Fields panel of the following screenshot, then click on Modeling in the Desktop ribbon and change the format to Currency>R Afrikaans(South Africa).
Also ensure that you change “Display units” to None as other post.
Thanks,
Lydia Zhang
Hi @tvukeya,
Based on your description, you want to format your number to be South African rand format, in this case, you can click your column in the Fields panel of the following screenshot, then click on Modeling in the Desktop ribbon and change the format to Currency>R Afrikaans(South Africa).
Also ensure that you change “Display units” to None as other post.
Thanks,
Lydia Zhang
@v-yuezhe-msft @cosborn1231Thanks for the solutions provided, but the only problem i have now is that the Modelling Menu Bar is all greyed out, Do you have any idea on how to solve this?
Hi @tvukeya,
Please firstly click your column or measure in the Field Panel as follows, then go to Modeling tab to change its format.
Thanks,
Lydia Zhang
Hi Tvukeya,
Going to the data table choose the column that your are getting the Total Receipting amount from and click to format the column with a comma ",":
When you are in the actual visualization options under the paint brush make the display as "None" so it resolves as the format you chose with the comma.
I hope this helps! Good luck,
Christian
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |