Forum Discussion
Dynamicaly named columns
Hi. Is there any way how to dynamicaly name column in table or matrix visualisation? I have simple table - revenue per month: Month - 2019 - 2018 - 2017 January - 100 - 80 - 60 February - 120 - ...
I tried this solution, but it does't work. Maybe I do something wrong. So that's why I didn't accept solution. But if it's a problem I will accept it.
v-juanli-msft
Community Support
Community SupportHi Anonymous
Could you share the screenshot of your original dataset when importing into Power BI?
The example of your first post shows the correct data structure as below, right?
| month | 2018 | 2019 |
| 1 | 20 | 20 |
| 2 | 20 | 20 |
| 3 | 20 | 20 |
I wonder how you update data (eg, from 2017~2019 to 2018~2020)
do you add new column "2020" with data in the original file and refresh from Power BI to add this data in?
Best Regards
Maggie