Forum Discussion
Dynamic column header in Table or Matrix
Hello Experts,
I need my table or matrix column to show month and year names according to the slicer value choose. Can anyone help me with this,
I am attaching my model and my Requirements:
My data Model:
My Requirement :
Many Thanks :
Hi Anonymous, I faced similar problem some time ago. Unfortunately until now I'm convinced that there is no way to achieve the desired result. Let me explan why and the workaround you can use:
- You can't change column or measure name dynamically. In data model wheteher it's a column or a mesure it has a static name you gave it when created, so in your case "Selected Month Revenue Amount" and "Previous Month Revenue Amount". You can change a display name when using measures on your viasulas, but again, it's not dynamic (e.g. instead of "Selected Month Revenue Amount" you might rename it to "CY Rev Amt" or something similar).
- To get a dynamic output, you need another measure that will calculate it for you. So this two new tehcnical measures would provide strings "Mar-20" and "Feb-20" that will change dynamically based on filter selection. Then you need to deside how to integrate it in the report.
- You might have dynamic info text as a separate visual, telling your user what period is selected now (text higlighted in yellow are the measures):
- Or you can add a pop-up explanation using visual header tooltip:
I hope it will help you!
Feel free to approach me if you like these ideas but need more details on how to implement them.
2 Replies
Hi Anonymous, I faced similar problem some time ago. Unfortunately until now I'm convinced that there is no way to achieve the desired result. Let me explan why and the workaround you can use:
- You can't change column or measure name dynamically. In data model wheteher it's a column or a mesure it has a static name you gave it when created, so in your case "Selected Month Revenue Amount" and "Previous Month Revenue Amount". You can change a display name when using measures on your viasulas, but again, it's not dynamic (e.g. instead of "Selected Month Revenue Amount" you might rename it to "CY Rev Amt" or something similar).
- To get a dynamic output, you need another measure that will calculate it for you. So this two new tehcnical measures would provide strings "Mar-20" and "Feb-20" that will change dynamically based on filter selection. Then you need to deside how to integrate it in the report.
- You might have dynamic info text as a separate visual, telling your user what period is selected now (text higlighted in yellow are the measures):
- Or you can add a pop-up explanation using visual header tooltip:
I hope it will help you!
Feel free to approach me if you like these ideas but need more details on how to implement them.
Thank you for your deatiled explanation. Much appreciated.