Forum Discussion

adamb123's avatar
adamb123
Regular Visitor
3 years ago
Solved

Wrong date format in visual

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

 

1 Reply

  • 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đź’ˇ