cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hamzahad91 Regular Visitor
Regular Visitor

Use Slicer to filter by month

I ould like to filter my data by time .

 

I have a column of Date :

date.PNG

When I use slicer I get this way of filtering :

filter.PNG

 

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: Use Slicer to filter by month

Hi @hamzahad91,

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

1.PNG

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.

2.PNG

Best Regards,
Angelia

1 REPLY 1
v-huizhn-msft Super Contributor
Super Contributor

Re: Use Slicer to filter by month

Hi @hamzahad91,

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

1.PNG

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.

2.PNG

Best Regards,
Angelia