Forum Discussion

LP2803's avatar
LP2803
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Date Slicer Not working

hi Team,

 

I have a Date column as below.  When I apply this as filter, i dont get Date slicer (kind of dumbell icon) instead i see this. 

 

Any idea what i should do to get Date Range?

 

 

 

 

  • if you make the visual bigger?   you need to make it quite big to get the slicer.

8 Replies

  • hkice's avatar
    hkice
    Icon for Advocate II rankAdvocate II

    The Slicer has a property called "Slider", make sure that it is set to "On"

    • LP2803's avatar
      LP2803
      Icon for Responsive Resident rankResponsive Resident

      hkice Thanks. The slider is on. But still i dont get slider

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion

        if you make the visual bigger?   you need to make it quite big to get the slicer.

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    use the drop down on the right of the slicer to select how you want to display your date.  Make sure the box is big enough to see it.  if its too small you want see it as an option.

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support

    Hi LP2803 ,

     

    I did not reproduce your problem.

    Is your date column a “Date" type?
    What's your Power BI Desktop version? Mine is 2.87.923.0 64-bit (November 2020)

     

     

    Try to open my .pbix file and check if the slicer is working properly.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • LP2803's avatar
      LP2803
      Icon for Responsive Resident rankResponsive Resident

      Hi Lionel, Thanks for your response. Yes my query is resolved. I did enlarge the slicer and then was able to see it.

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support

    Hi LP2803 ,

     

    Has your problem been solved?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.