Forum Discussion

Julaiha's avatar
Julaiha
Frequent Visitor
2 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
    2 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.

Anonymous's avatar
Anonymous
Not applicable
2 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.