Forum Discussion

Julaiha's avatar
Julaiha
Frequent Visitor
3 years ago
Solved

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 Augus...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
3 years ago

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