Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Title for Column Chart

Hi,

 

Request your guidance for resolving below requirement.

 

I would like to add a dynamic title to my column chart based on the slicer selection ( multiple choice option is on ).  

My column chart displays the sales from Jan 2021 to Dec 2021, so if I select Jan and April from slicer column chart title should accordingly  display the selected months. 

 

kindly advice

 

regards,

dsmitha

  • Anonymous you can add a measure and use concatenate to build the title

     

    My Title = 
    CONCATENATEX ( VALUES ( SlicerTable[SlicerColumn] ), SlicerTable[SlicerColumn], "," )

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

3 Replies

  • Anonymous you can add a measure and use concatenate to build the title

     

    My Title = 
    CONCATENATEX ( VALUES ( SlicerTable[SlicerColumn] ), SlicerTable[SlicerColumn], "," )

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi parry2k,

      Thank you very much for your super quick response, it worked 

      thanks again and subscribed to your youtube channel

      regards,

      dsmitha

  • Awesome Anonymous! Appreciate it Cheers!! Glad I could help.