Filters not showing the current time.

[Anonymous]

Hello,

I am giving the latest data (Date time wise) in the card visulaization. 

I have to obtain the exact count of data in the drill down that is present in the crad visualization by putting date time filters. But when I am drilling down for the details even though the latest time is there in the data, I am not able to get it in the filters.

For Example, the below picture gives us the latest data for current date and current time.

Now to get more details we go in the drill down. After drill down, suppose we go in the unregistered details, it is expected to give only 16 results for latest date and time. It is done through putting the filters in the table (out of the whole data) and only latest data should come. But in the filters pane, I am not able to get the latest data, and it is showing the time not the latest but also the for the previous time. 

In the above table, if we take only for 3:00 PM we will get the desired count of 16 , but even I put the "latest" in the date time, I should only be getting the data for 3:00 PM and not for 11:00 AM.

I have tried many things but the desrired count is not coming.

I hope the issue is understandable. Need help with this.

[Anonymous]

Hi @Anonymous ,

May I know how do you set the "drill down" and the filter for latest data in Filters pane? If you want to get the latest data on the latest date, you can refer the solution in the following threads to achieve it.

Latest Date Filter

Finding the most recent value

1. Create a column called MaxDate

    MaxDate =                    CALCULATE(MAX(yourtablename[yourDatecolumn]),FILTER(yourtablename[Name]=EARLIER(yourtablename[Name])))

What this does is computes the MaxDate by Name and popluates in all records grouping by Name.

2. Create a column called IsLatest

    IsLatest = If([Date]=[MaxDate],"Latest","Older")

3. Now create a report with relevant columns from yourtablename and use IsLatest column as a Visual Level Filter filtered for "Latest".

---

Best Regards

[lbendlin]

The Power BI service operates on UTC time.  Which timezone are you in?