Forum Discussion

hamzahad91's avatar
hamzahad91
Icon for Helper I rankHelper I
9 years ago
Solved

Use Slicer to filter by month

I ould like to filter my data by time .

 

I have a column of Date :

When I use slicer I get this way of filtering :

 

What I want to have is filtering by month as in this exemple

 

https://dpspowerbi.blob.core.windows.net/powerbi-prod-media/powerbi.microsoft.com/fr-fr/documentation/articles/powerbi-service-tutorial-slicers/20170710042105/pbi_slicer_outline2.png.

 

How to do that please ?

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi hamzahad91,

    You can use the custom visual: HierarchySlicer. When you add a date type field in it, it shows the result as follows.



    If you only want to contain year and month level, you can delete the Quarter and Day levels, you will get the expected slicer as follows.



    Best Regards,
    Angelia

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi hamzahad91,

    You can use the custom visual: HierarchySlicer. When you add a date type field in it, it shows the result as follows.



    If you only want to contain year and month level, you can delete the Quarter and Day levels, you will get the expected slicer as follows.



    Best Regards,
    Angelia