Forum Discussion
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
- parry2kSuper User
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!
- AnonymousNot applicable
Hi parry2k,
Thank you very much for your super quick response, it worked
thanks again and subscribed to your youtube channel
regards,
dsmitha
- parry2kSuper User
Awesome Anonymous! Appreciate it Cheers!! Glad I could help.