With Power BI Import Mode, you can change column name dynamically on visuals, to achieve this you have to follow below steps.
Follow these steps in order to change column name dynamically
1- Assign index to each rows using Index column under Power Query Editor.
2- After that create duplicate dataset for columns un-pivot.
3- Create relationship between both datasets on the basis of Index.
Support only Import mode, it will not work with Direct Query Mode, reason behind when you transform the columns it will switch your dataset as in Import Mode.
And Index column not support the Direct Query Mode.
Solution With Direct Query:
If you want to achieve this with in Direct Query then you have to prepare your datasets same like Import Mode final Datasets.
Watch video for step by step practical:
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.