Forum Discussion
How to create dynamic column names based on date in table visual or Power Query?
I was hoping to have dynamic column names and I was wondering if that is possible to do in either in power query or on a table visual?
Right now the column names are originally titled as such:
These are just supposed to represent the next month and month after the next. On my table visual I have them renamed like so:
I would like to have them show the acutal month name, so for today (6/23/2022), they would say July and August. Next month they would say August and September and so on. Is this possible to achieve either on the visual itself or in power query?
2 Replies
Hi scorbin ,
You cannot have dynamic names for a measure or column. But you can have dynamically measures to be displayed in a table visuals. Basically the field will change based on the measure you selected in a slicer.
This article used a chart but it is the same with table or matrix.
Dynamic Measure Selection in Power BI - Visual BI Solutions
https://www.youtube.com/watch?v=wfE9xUI5qxA
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
