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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
PP_aPPrentice
New Member

Dates hierarchy lost

Hi,
I have few visuals where one axis is based on date values. It was working just fine - there was hierarchy and I could filter visual to show data per day/week/month etc. 
Now seems it's all lost and I cannot recreate this hierarchy. 
What happened in the meantime (and what could cause it) is I created date table using formula to be used in one of the report's pages.
I will be thankful for any suggestions on how can I bring it back.

1 REPLY 1
DataNinja777
Super User
Super User

Hi @PP_aPPrentice,

The disappearance of a date hierarchy in your calendar table was caused by setting your calendar table as "Mark as date table".  (I personally prefer no date hierarchy as they take too much real estate in visualizations), but if you want them back, you can set your calendar table as unmark as date table.  

Sakiko_0-1693829853445.png

 

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors