Display latest date

[veakin]

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 ?

[veakin]

Thanks for your reply!

I am not sure why, but the heat map doesnt show any data, if I set the relative date format to 1...

Any suggestions on how to fix it? 

[Icey]

Hi @veakin ,

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

[veakin]

Yeah, but my dataset refreshes midday so it would be nice to have it showing the day before the current day.. if that makes sense

[Icey]

Hi @veakin ,

---

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.

[veakin]

Yeah I tried that at first... However, it showed today as the latest date but with no data on my map... don't know why..

[vivran22]

The 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

[vivran22 · Accepted solution]

Hello @veakin 

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