Custom Currency Formatting on Bar Chart

[newpbiuser01]

Hello,

I am trying to apply custom currency formatting to the metrics on barchart visuals - so if the sum of the cost would be greater than $1000, it would show as $1k, more than 1 million, would be $1M and so on. I have created a measure to format the number as follows, but when I try to apply this measure as a Y axis value, it won't allow me - what I mean by that is, I can try to drag the measure in the "Y" axis (I've even tried the "X" axis) field as much as I'd like, but nothing happens. Power BI will only allow me to put this field in the Tooltips field. I thought it might be because using this measure changes the CostCAD value to be a text, but I am able to use this measure in a matrix table without any issues. I'd really appreciate any help with this! 

Measure =

var CostCAD = 'All Measures'[Cost (CAD)]

return

SWITCH(TRUE(),

abs(CostCAD) < 1000 && not(ISBLANK(CostCAD)),CONCATENATE("$",format(CostCAD,"CURRENCY")),

abs(CostCAD) >= 1000 && abs(CostCAD) < 1000000, CONCATENATE(FORMAT(CostCAD/1000,"Currency"),"K"),

abs(CostCAD) >= 1000000 && abs(CostCAD) < 1000000000, CONCATENATE(FORMAT(CostCAD/1000000,"Currency"),"M"),

abs(AssetCostCAD) >= 1000000000, CONCATENATE(FORMAT(CostCAD/1000000000,"Currency"),"B")

)

Thank you! 

[Ashish_Mathur]

Hi,

As far as i know, in the X-axis, one can only drag numeric fields.

[newpbiuser01]

Hi @Ashish_Mathur would you know if it is possible to label the data with custom formatting? So as opposed to saying 1,000,000,000 or 1bn I'd like t say 1B.