Dynamic Title

Q&A
,
1

Hi Everyone,

I need to add title to pivot table visual. The visual has filter using data column which filters last two years. Other than this, there are no filters related to date or year. The visual shows percentage difference from previous year. So when last 2 years is filtered, it displays 2023 and 2024. In this 2023 will be null and 2024 will give percent difference from 2023. Since I need to add dynamic title like “2023 & 2024 YoY”. Similarly, I need to add for month , week and quarter.

Kindly help me to solve this.

Thanks,
Kripa M

2

Hi @Kripa_Magesh

Option 1: Show parameter value, in title, based on your selection.
Option 2: Use a table visual to display the right values and overlap as title.

Both options arent perfect and are only workarounds.

BR

1 Like
3

Hi @ErikG ,

Option 1: Data filter is relative date which shows last N years. And data filter should not be added to the sheet also. If I create parameter for date, can we just apply filter without adding to sheet?

4

Yes, you dont have to put the filter/control to the sheet.

5

Hi @Kripa_Magesh,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @Kripa_Magesh,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!