Use Slicer to filter by month

[hamzahad91]

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/documentatio....

How to do that please ?

[v-huizhn-msft · Accepted solution]

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