Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
gooranga1
Power Participant
Power Participant

Date Format in a Hierarchy

I have just noticed that our dates are not being formatted correctly in a hierarchy. I have added Date to a hierarchy called Calendar. This is definitely formatted as yyyy-mm-dd. 

 

However if I add the hieratchy to Axis in a bar chart and drill down I get the following. So the date is mm/dd/yyyy hh:mm:ss AM/PM. IF you drill directly to the bottom of the hierarchy using the connected double down arrow the format is correct but not when you drill down from year to month to date.

 

DateFormat.PNG

2 REPLIES 2
gooranga1
Power Participant
Power Participant

This happens on a Stacked Column chart but on a Line and Stacked Column Chart I have discovered.

 

Anonymous
Not applicable

Hi @gooranga1,

 
Since @v-haibl-msft has already report this issue, you can take a look at below link:
Drill down on date in column chart displays date/time format

 

Regards,
Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors