Forum Discussion
Dynamic columns names change ever month
Hello Everyone, This Data set has multiple columns where in Column 7 to Column 12 gets refreshed ever month. Example : For this month data starts from Jan 2023 to June 2023 F...
MFelix
Super User
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
