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

How to filter out an item in a slicer?

Hi Guys, 

I need to filter out a item in my date slicer  . I know that if this was a visual it would be easier since visual filter was there .  In the below image i dont want to show blank.  Another option i  saw was that i bring in another slicer and select all values except blank and hide it. Is this the best option available ? 

 

 

Date Slicer.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to filter out an item in a slicer?

@ajin Pleae try to create a "New Table" with single column "Year" using below DAX (Which will be source for your slicer) and then create a relationship between this new slicer table and the main table (in this case it will be on Year field).

 

TestYear = FILTER(DISTINCT(_DimDate[Year]),[Year]<>BLANK())


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





1 REPLY 1
Super User
Super User

Re: How to filter out an item in a slicer?

@ajin Pleae try to create a "New Table" with single column "Year" using below DAX (Which will be source for your slicer) and then create a relationship between this new slicer table and the main table (in this case it will be on Year field).

 

TestYear = FILTER(DISTINCT(_DimDate[Year]),[Year]<>BLANK())


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !