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.

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

v-yanjiang-msft Hi, your solution partially works. It filters data as I expect but the data displayed on the calendar is wrong even tho data is filtered correctly. Data is up to 28/07/23 but the calendar i showing till 15/07/23 even tho it filters till 28/07/23 which is missleading. I dont know what is causing this interaction.

 

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
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.