Forum Discussion

evahohk's avatar
evahohk
Helper 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 Da...
  • 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.

Nathaniel_C's avatar
Nathaniel_C
Community 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
Helper 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
    Community 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

    • evahohk's avatar
      evahohk
      Helper I
      4 years ago

      I actually copied measures from another website. 
      How can I change the dynamic heading based on selection ?
      e.g. Period Ending January 2022, then it will show Reporting period : Jan 2022
      or select period ending January 2022 to February 2022, it will show Reporting period : Jan 2022 to Feb 2022
      Sorry I'm not too sure how can I share .pbix. in this platform. 
      I have attached screenshot of the Power BI file.