Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |