Bar chart displaying hours and minutes instead of months when a single year is selected

[lailarhc]

Hello.
I have a bar chart that displays the average number of courses ([Nome Evento]) in a given time.

Here's the expression of the chart's measure:

Count(distinct [Nome Evento]) / Count(distinct [Nome do servidor])

Here's what it looks like when a single year is selected:

It's a single dot, with the scale showing hours and minutes.

Here's another bar chart that displays the actual number of courses taken when a single year is selected:

In both cases I have the Continuous option in the X-Axix tab selected, as seen bellow:

How can I make the first bar chart behave like the second? Why is it behaving the way it is?
Thank you in advance

[AshutoshBhumkar]

Hello,

Try disabling below property.

Thanks,
Ashutosh

[lailarhc]

If I do that, it only shows the year:

I need it to show the months as well.

[AshutoshBhumkar · Accepted solution]

Okay. For that you can create a drill down dimension (Year->Month)

[lailarhc]

It worked, thank you!

[AshutoshBhumkar]

Great 🙂