cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shalin
Frequent Visitor

Can you filter a slicer?

I have a data set which was confirmed delivery dates against Purchase orders. If the date isn't confirmed on our ERP system, the date is blank, which shows up on BI at 1/1/1900. I would like a date slicer which can filter out that date. See this screenshot https://www.dropbox.com/s/z28vx7gcixw43i3/BI%20screenshot.pdf?dl=0 (apologies for my shoddy redacting!). The bottom left is the slicer which you can see shows a timeline from 1900 to today. At the top is a card showing the earliest delivery date. Because it is a card I was able to filter out 1/1/1900 so that the card is actually useful. 

 

When I try and drag anything into the visual filter for the slicer however, nothing happens. I assume that's by design. So basically how can I get around this so that I can filter a slicer, to only slice between the options I want? 

 

The point of the report is for users to be able to know when a certain PO is due to arrive. So I would rather keep the 1/1/1900 data in the table, as it doesn't tell them when it is coming, but it does tell them that something is coming. Which is why I want to find a way which doesn't put a filter on the entire report? 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-cherch-msft
Microsoft

Re: Can you filter a slicer?

Hi @Shalin

 

The similar idea is under review.You may check the other ways in this post.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
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

3 REPLIES 3
Super User II
Super User II

Re: Can you filter a slicer?

you can add a page/report level filter on that dimension, that should prevent the values appearing in the slicer

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Datanaut!

Highlighted
Shalin
Frequent Visitor

Re: Can you filter a slicer?

Hi Stachu,

 

That filters out all of the data on the whole page/report though. Ideally I would like the table to show all the data, but that particular slicer only shows the filtered date ranges

Microsoft v-cherch-msft
Microsoft

Re: Can you filter a slicer?

Hi @Shalin

 

The similar idea is under review.You may check the other ways in this post.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors