Forum Discussion
Dynamic columns names change ever month
Super UserHi R_K_Damera ,
For this I believe that the best option is for you to unpivot the data that way you will get a line for each month and you can then use that column in a matrix visualization in order to update the data automatically.
Hi,
I have tried using unpivot in the matrix visual and when ever user exported the data we are getting attribute, value only
User wanted the data in the sequence column as the input file
- MFelix
Is the export from the service or PBI desktop?
In the service you can download the data exactly how you see it in the visual.
Using desktop and need help on the same
- MFelix
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