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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
RobBenco
New Member

Date Hierarchy is changing from month year to year only

I have a visual that I show the date hierarch Year and month.  But when I close and open the report or publish the report to our PowerBI server, only date heirarchy by year is displayed.  How do I prevent the visual from changing and keep the year month hierarchy.

This is how I want it to look.

RobBenco_0-1739204698483.png

 

This is how it looks when it is reopened or opened from our PowerBI server

RobBenco_1-1739204859299.png

 

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @RobBenco,

It seems like the hierarchy level changes, perhaps you can try to use bookmark to save the current level, and you can simply use this to restore the hierarchy level.

Create report bookmarks in Power BI - Power BI | Microsoft Learn
In addition, you can also tried to create a calculate column with year month and use this to create visuals, and its group should not auto changes.

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
lbendlin
Super User
Super User

Publish it when the hierarchy is expanded.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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