Forum Discussion
Select Latest Value from filter in Power BI Report
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
Super UserHi,
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.
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-msftCommunity Support
Anonymous,
You may take a look at the following post.
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