Forum Discussion

evahohk's avatar
evahohk
Icon for Helper I rankHelper I
4 years ago
Solved

Convert Date to MMM YYYY with Display title function

I have used display title function to display text box value based on filters in Power BI

DisplayTitle  =

"Reporting period : "
& CONCATENATEX (
VALUES(('ABC Data'[Period Ending]))
, ('ABC Data'[Period Ending])
," , "
)



That's how it shows in the table How can I change it from 1/3/2022 to Mar 2022 ?
I'm looking for formula to change 1/3/2022 to Mar 2022 in the above coding 
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi evahohk 

    Thanks for your reply.

    >> If I select Period Ending January 2022, then it will show the heading as Reporting period : Jan 2022

    You can try this measure

     

    title = "Reporting period : " &FORMAT( SELECTEDVALUE('Table'[Column1]),"MMM YYYY")

     

     

    >>  select period ending January 2022 to February 2022, it will show Reporting period : Jan 2022 to Feb 2022

    In fact, if only one date is selected, the above effect cannot be achieved, so usually we need to select two dates in the slicer to get the period

    try this measure,

     

    title = 
IF(ISFILTERED('Table'[Column1]),IF(ISBLANK(SELECTEDVALUE('Table'[Column1])),"Reporting period : "&FORMAT( minx(ALLSELECTED('Table'),[Column1]),"MMM YYYY")&" to "&format(MAXX(ALLSELECTED('Table'),[Column1]),"MMM YYYY"),"Reporting period : " &FORMAT( SELECTEDVALUE('Table'[Column1]),"MMM YYYY")))

     

    Best Regards,

    Community Support Team _Tang

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

9 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi evahohk 

    Please try this:

    Format = 

var _date = FORMAT(MAX('Table'[Column1]),"MMM YYYY")

return concatenate ("Reporting period : ",_date)


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

    • evahohk's avatar
      evahohk
      Icon for Helper I rankHelper I
      4 years ago

      Thanks getting back to me. Sorry that I'm still a beginner of Power BI
      Can you please advise the procedure ? Do I need to create a new measure as below ? 

      Format = 

var _date = FORMAT(MAX('Table'[Column1]),"MMM YYYY")

return concatenate ("Reporting period : ",_date)

       or how can I add the above coding in DisplayTitle ? 

      DisplayTitle  =

      "Reporting period : "
      & CONCATENATEX (
      VALUES(('ABC Data'[Period Ending]))
      , ('ABC Data'[Period Ending])
      ," , "
      )
      • Nathaniel_C's avatar
        Nathaniel_C
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Hi evahohk ,

        Please tell me why you wrote your measure with Values() and Concatenex()? Can you share your .pbix?


        Let me know if you have any questions.

        If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
        Nathaniel

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi evahohk , right click on your file and go to share, then copy link.  You can then post the link in your reply.

    Nathaniel

     

     

     

     

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi evahohk 

    >> I have used display title function to display text box value based on filters in Power BI

    Could you share some sample data in 'ABC Data'[Period Ending]? (If you can't share files, you can share screenshots, thanks.)

     

    Best Regards,

    Community Support Team _Tang

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

    • evahohk's avatar
      evahohk
      Icon for Helper I rankHelper I
      4 years ago

      Hi Tang,

      How can I change the dynamic heading based on selection ?
      e.g. If I select Period Ending January 2022, then it will show the heading as Reporting period : Jan 2022
      or select period ending January 2022 to February 2022, it will show Reporting period : Jan 2022 to Feb 2022

       

      • v-xiaotang's avatar
        v-xiaotang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi evahohk 

        Thanks for your reply.

        >> If I select Period Ending January 2022, then it will show the heading as Reporting period : Jan 2022

        You can try this measure

         

        title = "Reporting period : " &FORMAT( SELECTEDVALUE('Table'[Column1]),"MMM YYYY")

         

         

        >>  select period ending January 2022 to February 2022, it will show Reporting period : Jan 2022 to Feb 2022

        In fact, if only one date is selected, the above effect cannot be achieved, so usually we need to select two dates in the slicer to get the period

        try this measure,

         

        title = 
IF(ISFILTERED('Table'[Column1]),IF(ISBLANK(SELECTEDVALUE('Table'[Column1])),"Reporting period : "&FORMAT( minx(ALLSELECTED('Table'),[Column1]),"MMM YYYY")&" to "&format(MAXX(ALLSELECTED('Table'),[Column1]),"MMM YYYY"),"Reporting period : " &FORMAT( SELECTEDVALUE('Table'[Column1]),"MMM YYYY")))

         

        Best Regards,

        Community Support Team _Tang

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