Select Latest Value from filter in Power BI Report

[Anonymous]

Hi,

I am very new to Power BI.

Is there any way to select Latest value in the filter?

For example. If I have a table in which I have Period values like P1, P2, P3.

Now we have data till 'P4' so 'P4' is the latest value. Is there any way that the latest value will be selected whenever user see the report.

Thanks!

Regards,

Poonam

[Hardik]

Hey could you provide a a better explanation about your requirement so that we can help

[Anonymous]

Hi,

I have one field called 'Period' which has values P1, P2, P3 and P4. (It's nothing but Month - Jan , Feb , Mar and Apr) So here we can say we have data till April. When I show filter on sheet, the latest value is P4 now. So I should get P4 by default selected in filter when I load reports. Next month When the latest Value is 'P5', the selection should change to 'P5'.

Is there any way to do that in Power BI?

Thanks!

Regards,

Poonam

[Ashish_Mathur]

Hi,

Infact if you do away with P1,P2,P3,P4 and work with Months, you can use relative date filters to show data for the current month.  Please read up on relative date filters.

[Anonymous]

Hi Ashish,

Thanks for your reply.

In the datatabase, we don't get data imeediately whenever we enter in the new month. We have automated jobs scheduled when we get the source file. So now we are in 'June' month but we have data till 'May' only and that also we got in last week. So whatever is the maximum value , I want to select that and show the data in the report based on that period. Is there any way to load (Autoselect) the maxium (Latest) value in the report?

Regards,

Poonam

[v-chuncz-msft]

@Anonymous,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Default-Behavior-Date-Filter-to-Most-Recent/m-p/235728#M104911

[Anonymous]

Hi @v-chuncz-msft,

Thank you for your reply.

I tried the same which is mentioned in the above link.

I created one cutom column with the below expression:

if [Period]=max([Period]) then "Yes" else "No" .

I am getting Expression Error: 'max' wasn't recognized.

Can you please help me on that?

Thanks!

Regards,

Poonam

Regards,

Poonam

[Anonymous]

Depends on your requirements, there are several ways to get the latest value. For example, if you latest value refers to date time, you can refer to https://blogs.msdn.microsoft.com/lukaszp/2015/08/08/finding-the-latest-date-in-power-bi-desktop/