Forum Discussion
Currency symbol formatting on the scatter plot
Hi Experts!
How can I change the formatting on X-axis and Y-axis on Scatter Plot to show values in “$B”? The default Power BI formatting for bilions is “bn”, whereas I would like to have “B” instead.
Example:
Power BI Formatting: $6bn
My desired outcome: $6B
I know I can use “FORMAT” DAX function, but this will work only with tables because the data type will be changed to text, so it will not be working for the charts. So this doesn’t solve my problem. Thanks!
2 Replies
- lbendlin
Super User
If this is important to you please consider voting for the existing idea at https://ideas.powerbi.com - it has been open for years.
I tried a way and it worked to format data values:
Under Visualizations, Format visual, General/Data format/ apply settings to the column you want to format and then change the formatting under "Format options", that should work
