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 in slicer only months which are in the table not all of them. 

 

Thank you for your help. 

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!

3 Replies

  • 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!