Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Between slicer showing more dates than data

Hi, I have data from couple agencies that are tracking working hours. I have made simple calendar to use in the report. However when I when I add calendar in to slicer it shows all dates available ...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Justas4478 ,

    I make a mistacke, change the MIN where I framed with red lines to MAX.

    Get the correct result:

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

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

Justas4478 , Create a measure on fact( Meausre not column) and use that visual level filter slicer and chck for not blank