Date Slicer - Data will not populate when slicer is set to max date

[yoyama801]

Hello,

I've created a report to show outstanding investment balance that user can toggle the date slicer to see the investment names, outstanding balance, and earned interest, etc but I am having an issue where my visual will not populate data if the date slicer is set at the maximum date.

I've taken off the investment name / interest for confidentiality purposes but the problem can still be seen below.

If I change the date by 1 day less than the maximum date then the visual populates.

I do have a visual filter on the date slicer set to cap at "Today()-1" but same issue when I remove the visual filter.

I've seen this before as well but any help or suggestions to overcome this is appreciated.

Thank You

Yo

[v-xiaotang]

Hi @yoyama801 

you can use this measure to check whether the slicer is working,

test = 
    var _t=ALLSELECTED('Date'[Date])
return FIRSTDATE(_t) & " " &LASTDATE(_t)

 if the slicer is working fine, then check your Outstanding Balance, is the Outstanding Balance a measure? Could you share its content for us to check it? Thanks

Best Regards,

Community Support Team _Tang

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

[dvl_ctaul]

Additional info would be helpful. Also an explanation of what you're trying to accomplish might be useful for generating alternative ideas for reaching the same goal.