Month in Date Hierarchy

[Julaiha]

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?

[Uzi2019]

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

[Anonymous · Accepted solution]

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

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

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

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]

Add fact columns to your visual.