Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicer with date

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 ...
Show and Tell
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Anonymous ,

     

    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!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try to restrict by measure

Create a measure

countrows(Table)

 

Anc in visual level filter check this is not blank

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi  Anonymous ,

     

    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!