Currency symbol formatting on the scatter plot

Power BI
1

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

Hi @lennie.hoppe. You can use the Format input box in the Formatting section of the toolbar to format a value as you wish.

eDNA Forum - Scatter Plot Currency Symbol Formatting - 1
eDNA Forum - Scatter Plot Currency Symbol Formatting - 11920×1282 151 KB

Hope this helps.
Greg
eDNA Forum - Scatter Plot Currency Symbol Formatting.pbix (403.2 KB)

3

Hello @lennie.hoppe

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

4

It works, thank you so much Greg. :grinning: