Format to currency but the data was not showed in Bar Chart

[Anonymous]

Dear team,

I would seek supporting from team. I have slicer 1. AMT, 2. HL and 3. Unit

I set DailyAct as number and i did DAX to compute Sale based slicer. However, when select Amt (format as currency) the data was not showed in bar chat. the flow stated below:

-Data type of DailyAct is number

1. DAX

2. Select Unit, the data was showed in bar chart

3. Select AMT, the das was not showed in bar chart

I am facing in number 3; therefore, I would like to seek for solution from team.

Thanks

Aynar

[tamerj1]

Hi @Anonymous 
FORMAT Function returns text data type which of course cannot be plotted on a chart. Try using CONVERT function

CONVERT ( your dax calculate formula, CURRENCY )

[Anonymous]

Dear @tamerj1 ,

Thanks you so much it works. But I aim bart chart show value with USD Jan-$5140... when select AMT and other jus show value without USD when select HL and Unit.

I am appricated for your prompt help.

Thanks,

Aynar

[tamerj1 · Accepted solution]

@Anonymous 
I hope this can help 

https://www.youtube.com/watch?v=1Yi1xn4RPMc

[Anonymous]

Hi @tamerj1 

Thanks you so much, I got the solution.

Thanks

Aynar