cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubs Member
Member

Date In Build Hierarchy Issue

Hello,

As Power BI Desktop have a In build Date Hierarchy, But that is not working fine.

Example: if my data is upto january 2018 and i have drag drop 2 filter or slicers from that in Build Hierarchy(Month and Year from Date Hierarchy) then if i select "2018" from Year slicer it should give only "January" in my Month slicer(as my data is upto Jan 2018 only). But this not the case with In Build Date Hierarchy, as when i select 2018 it shows all 12 months in my Month slicer instead of displaying only one month. Though if i select any month except Jan then all data in my charts are displaying blank which is correct.

But why it is displaying all the extra months.

 

Hope I am clear with my query. Please revert to resolve this issue.

 

Thanks

2 REPLIES 2
Community Support Team
Community Support Team

Re: Date In Build Hierarchy Issue

@Shubs,

 

It seems to work for me. If convenient, share a complete example.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Shubs Member
Member

Re: Date In Build Hierarchy Issue

Hi @v-chuncz-msft
Thanks for the reply
Please Check this image.Max date of my data is 23rd Feb 2018(you can see that in Date Slicer). But when i selct 2018 from my year filter then it not filtering the corresponding months, instead showing all the 12 months.Similarly for quartersb too.

I have used Date In Build Heirarchy.

Issue.PNG

 

If any concern regarding any more explainations of this issue please let me know.

Thanks

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,221)