Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I clicked the "x" next to Month and Day under the date hierarchy for "DOI" (shown below).
How do I get Month and Day to appear again under DOI?
DOI Date Hierarchy
Thank you.
Solved! Go to Solution.
Power BI default slicer doesn't support date hierarchy. You can use Timeline slicer custom visual or hierarchy slicer to display date hierarchy.
Regards,
Lydia
Power BI default slicer doesn't support date hierarchy. You can use Timeline slicer custom visual or hierarchy slicer to display date hierarchy.
Regards,
Lydia
Right click the DOI again in the VISUALIZATIONS -> Vales section and select Date Hierearchy.
Thanks
Raj
Date Hierarchy is selected (see screenshot below).
I clicked the "x" next to Month and Day under the date hierarchy for "DOI" (shown below) which removed Month and Day from the hierarchy list. Year is still showing.
How do I get Month and Day to appear again under DOI?
Date Hierarchy
AFter you removed the Month and Day , if you select the Date Hierarchy option, it should bring back the Month and Date.
Thanks
Raj
I think slicers only allow the Year from the incident date hierarchy.
However, Raj's solution does work for charts.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 50 | |
| 46 | |
| 41 | |
| 39 |