Forum Discussion
Dynamic columns names change ever month
Using desktop and need help on the same
Hi R_K_Damera ,
The main question on this case is the usage of different columns in your visualization since when you name a specific column to Jan 23 that is the name it is going to have in the visualizations also, there is no way for you to have a dynamic naming based on columns names itself.
The dynamic naming can be achieved using the values on a table has I refer doing the unpivot but not from that table exactly.
There are some options to change your model in a dynamic way however that will break your table visualization since has I refered previously the columns name used on the visuals are exactly the ones you have on your model or that you overwrite on the visual.
Only option I can suggest is getting generic names for the columns but I assume you users also want to have the correct dates being used in the visual/download.
Check if this video can help you on dynamic naming.
https://www.youtube.com/watch?v=kwf-E3a3aOE
https://www.youtube.com/watch?v=gndANP-ObQg