Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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

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

format currency.JPG

 

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

filter_unit.JPGChart_show.JPG

 

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

filter_amt.JPGBar chart_no.JPG

 

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

 

Thanks

Aynar

1 ACCEPTED SOLUTION

4 REPLIES 4
tamerj1
Super User
Super User

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
Not applicable

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.

format currency1.JPGChart_show_currency.JPG

I am appricated for your prompt help.

 

Thanks,

Aynar

@Anonymous 
I hope this can help 

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

Anonymous
Not applicable

Hi @tamerj1 

 

Thanks you so much, I got the solution.

 

Thanks

Aynar

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.