I created a calculated column for age of ticket as shown below.)
This is the DAX code used: Age of ticket(in days) = DATEDIFF( Fact_incident[Created DateTime], TODAY(), DAY
CreatedDate Age of ticket(in days)
When I tried to creat a chart from the above data, the Age of ticket(in days) is placed in the values but it changes to a count which gives me a wrong figure. I want the exact numbers above to be on the chart and not changing it to “count of Age of ticket(in days)”
Please what should I do? Need your help.