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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Julaiha
Frequent Visitor

Month in Date Hierarchy

Hai Expert, I have question.

 

In my table , i have a created date column, when i drag month into a dropdown slicer from created date hierarchy its hows all 12 month but actually its only has August, September and October. How can my dropdown only shows the exist month in created date column without joining from lookup date?

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Julaiha ,

Sorry, this is the design concept of power bi for dates. When your date relates to a hierarchical structure, whether it is a month or a quarter, it will all be displayed.

 

You can manually filter the months with data by clicking on the slicer and then selecting the filter next to it

vyangliumsft_0-1698226980221.png

You can also create a calculated column and use this calculated column as a slicer.

Month = FORMAT('Table'[Date],"mmmm")

vyangliumsft_1-1698226980224.png

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Uzi2019
Super User
Super User

Hi @Julaiha 
Dont take the Month from your calculated Date column.It is PBI behaviour to show continuous dates and months of calculated date column.

Try to take data from your orignal date column which has only Aug Sept Oct data.

 

If my post helps please give kudos and accpet it as a solution!
Thanks

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
v-yangliu-msft
Community Support
Community Support

Hi  @Julaiha ,

Sorry, this is the design concept of power bi for dates. When your date relates to a hierarchical structure, whether it is a month or a quarter, it will all be displayed.

 

You can manually filter the months with data by clicking on the slicer and then selecting the filter next to it

vyangliumsft_0-1698226980221.png

You can also create a calculated column and use this calculated column as a slicer.

Month = FORMAT('Table'[Date],"mmmm")

vyangliumsft_1-1698226980224.png

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

Add fact columns to your visual.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors