Slicer with date

[Robinho]

Hello,

I would like to ask a question. I have a problem when I'm using a slicer with the date it is showing all months and in the table, I have only three months.

I would like to have in slicer only months which are in the table not all of them. 

Thank you for your help. 

[amitchandak]

@Robinho , Try to restrict by measure

Create a measure

countrows(Table)

Anc in visual level filter check this is not blank

[Robinho]

Hello @amitchandak ,

I tried it not sure if correct but I don't think so if it is working.

Please can you send here the procedure on how to do it?

Thank you very much.

[v-kelly-msft · Accepted solution]

Hi  @Robinho ,

Because you are using "time intelligence",it will automatically create a hidden date table,details is as shown below:

One way to solve this problem is to create 2 calculated columns as below:

Year = YEAR('Table'[Date])

Month = FORMAT('Table'[Date],"MMMM")

Then put the 2 columns in the fields of slicer, and you will see:

You could check my sample attached.

Best Regards,
Kelly

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