Display Data of Latest Date

[guptash]

Hi All,

I have a chart which has data for all dates from last 30 days. I want to show data of only latest date as the default visible data on my chart and then let user decide what data from previous days is required by giving an option of date filter.

Dataset is refereshed each day and value of latest day is added to it.

Whenever I open my report I get values of all 30 days on chart instead I want value of only latest day.

Hope I am able to explain my scenario.

Please let to me know how to achieve this task.

Thanks,

Shivam 

[Greg_Deckler]

So, you probably want a measure along the lines of:

Measure = IF(ISFILTERED([Date_Column]),[Date_Column],MAX([Date_Column])

Tough to really say without sample data, etc. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[guptash · Accepted solution]

Hi Greg,

Thanks for the link. Apologies that the information was enough. 

But eventually I figured out the solution.

Solution:

I am using relative option in the slicer which gives me the latest date and have bookmarked that page. So now whenever I open the report, I get to see the bookmarked page having data with latest date.

-Shivam