Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Vanessa250919
Helper IV
Helper IV

slicer Date filter

HEllo,

 

I need one filter slicer date for my report with calendar, it's possible like this blue slicer ? Because de basic slicer date in PowerBI have no filter function ? 

 

Vanessa250919_0-1623837274723.png

 

1 ACCEPTED SOLUTION

Hi,  @Vanessa250919 

 

First, you need to fill in the specific value to apply.

Like this:

vjaneygmsft_0-1624003810607.png

Secondly, Slicer is used to filter the data. If you want to present the data, you can use other visuals, and then create a date measure according to your needs.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-janeyg-msft
Community Support
Community Support

Hi, @Vanessa250919 

 

You can filter the date first in the filter pane in the slicer visual.

Like this:

 

vjaneygmsft_0-1624001856810.png

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-janeyg-msft Helo thanks for your answer but I can't click to apply filter 

@Vanessa250919 Is your data continuous?

@v-janeyg-msft  I try to make a filter like your example 

 

Vanessa250919_0-1624002949270.png

 

@v-janeyg-msft I need a filter that adapts with the data, not static filter MIN and MAX date 

Hi,  @Vanessa250919 

 

First, you need to fill in the specific value to apply.

Like this:

vjaneygmsft_0-1624003810607.png

Secondly, Slicer is used to filter the data. If you want to present the data, you can use other visuals, and then create a date measure according to your needs.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.