Dynamic Title

[Oros]

Hello,

I have a calendar with a dropdown selection of the month and a parameter (last X months).  How do you make a measure so that all the selected months will show either in a title of in a card?  It should show the selected month AND the previous X months selected.  Thanks.

For example, if March 2024 is selected, and last 3 months is also selected in the parameter,  then the measure (title or card) should show  December, January, February and March

If July 2024 is selected, and last 2 months is also selected in the parameter, then it should show May, June, July

[danextian · Accepted solution]

Hi @Oros 

A similar use case was already posted. Attached is the sample pbix

[Anonymous · Accepted solution]

Thank you danextian and lbendlin 

Hi, @Oros 

I wish you all the best. Previously Super user have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[Oros]

Hi @Ashish_Mathur,

As always, you aare very helpful and kind. 🙂  Thank, your solution works! 

[Ashish_Mathur]

You are welcome.

[Anonymous · Accepted solution]

Thank you danextian and lbendlin 

Hi, @Oros 

I wish you all the best. Previously Super user have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[danextian · Accepted solution]

Hi @Oros 

A similar use case was already posted. Attached is the sample pbix

[lbendlin]

Have your report users asked for this?  Seems a bit ambiguous and rife for misinterpretation.

For example if March 2024 is selected - what should I do if I only want March 2024? Do I have to select at least one prior month?

[Oros]

Hi @lbendlin ,

Thank you for your quick reply.  The report users normally get confused as to what months are covered with the selection, especially if the selected X months is more than 1 month.  That is why a dynamic title will help.
Yes, when they select a month from the dropdown, they also have to select at least 1 previous month. 

Thanks again.