Date field not accepted in Y axis Clustered Bar Chart

[PowerRon]

Hi

I want to show the three days with most transactions in a clustered bar chart.
When I put my Date hierarchy on the Y axis it looks like this

I can drill down to the lowest level.
But I want it to show only the date, like 31-01-2022
When I delete Year, Month and Quarter form the hierarchy or I put the Date field (the one above the hierarchy) in the Y axis , it becomes like this


Not able to drill down and showing only month and year.
When I change this clustered bar chart in a table, it looks like this


Why can't the bar chart shwo the dates like 31-01-2022??

Regards 

Ron

[PowerRon]

Thnx @olgad 
it's the solution 🙂

[olgad · Accepted solution]

Hi, change to categorical instead of continuous