The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
@Anonymous
I hope this can help
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 )
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
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |