Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Select Latest Value from filter in Power BI Report

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

Need Help

7 Replies

  • Hardik's avatar
    Hardik
    Icon for Continued Contributor rankContinued Contributor
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        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.