cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Microsoft
Microsoft

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

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

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

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors