Forum Discussion

prakash11440278's avatar
prakash11440278
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Latest reporting cycle filter in report

Hi Power BI Team,

I have a requirement to show the latest reporting cycle as a filter in my report based on the cycle status "Unlock" value. 

Currently reporting cycle is showing as September that i want to be displayed as "December" when i open the report as latest reporting cycle. Please help.

 

 

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi prakash11440278 ,

     

    You can place the created measure in "Filters on this visual", select the corresponding date, and display the default result in the card.

     

    measure = SELECTEDVALUE('Table'[Cycle status])


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

     

    Best Regards,
    Henry

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    prakash11440278 , Create a measure like

     

    measure =
    var _max = maxx(filter(Table, Table[Cycle Status] = "Unlock"),[Cycle])
    return
    maxx(filter(Table, Table[Cycle Status] = "Unlock") && [Cycle] =_max,[Reporting Cycle])

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi prakash11440278 ,

     

    You can place the created measure in "Filters on this visual", select the corresponding date, and display the default result in the card.

     

    measure = SELECTEDVALUE('Table'[Cycle status])


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

     

    Best Regards,
    Henry

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • prakash11440278's avatar
      prakash11440278
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Hi v-henryk-mstf ,

      Thanks a lot for your reply.

      Here my requirement is to display the "December" reporting cycle in slicer based on the Cycle status column, when i always open the report based on the cycle status field "Unlock".