Wrong date format in visual

[adamb123]

Hi,

I'm having a problem with format of date fields on my axis in my stacked column chart. I have changed the format of the Date column in dataset to date - short date:

But in my visual on X axis I only get the day number, but I want to see the whole shortdate, e.g. 8/18/2023 not only 18. I think, it's because of the date hierarchy, but I did not created one, it was created automatically. Is there some possibility to show the whole date? Do I have to create a separated calendar table? 

Thank you

[Idrissshatila · Accepted solution]

Hello @adamb123 ,

Power bi automatically creates a date hierarchy, so if you want the date you just click on the arrow and switch to date.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡