Forum Discussion
Display latest date
Hi,
I have a heatmap that displays numeric values of accounts across the world. I would like it to filter on latest day.
I have a date hierarchy and I have tried several things from other post in here, unfortunately in vain..
Can someone help me out with this ?
Hello Anonymous
Have you tried the relative date slicer?
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)
https://www.vivran.in/
Connect on LinkedIn
7 Replies
Hello Anonymous
Have you tried the relative date slicer?
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)
https://www.vivran.in/
Connect on LinkedInThe relative date slicer picks up the latest date as per the system calendar and not in the dataset. What is the latest data point in your model?
Can you share sample pbix/data file?
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter
Hi Anonymous ,
it would be nice to have it showing the day before the current day.Have you tried to set "Relative date" as "is in the last 1 days"?
In addition, please pay attention to timezone between your local datetime and Power BI Service. When you publish a report to the Power BI Service, the Power BI server’s date and time is based on UTC, and it might be different from your local timezone.
For more details, please check: Relative Date Slicer for Your Local Time Zone in Power BI - RADACAD.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Sorry to reply late. Could you show me some screenshots? And it would be better if you could create a sample .pbix file for test. Please don't contain any sensitive information.
Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Icey
