Forum Discussion
Dynamically update the Column Headers in Table Visualization.
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
For next month data starts from Feb 2023 to july 2023
Here Column 7 starts from jan 2023, Column 8 starts from Feb 2023, Column 9 start from mar 2023,,, Column with jun 2023
For next month Column 7 start with Feb 2023, Column 8 start with Mar 2023,,, Column 12 with July 2023
The requirement is
1) All the Column present in the data set should be placed in TABLE Visualization only.
Problem :
1) when ever the Current month data is added to table Visualization ie., jan 2023 to Jun 2023 the visual looks fine.
2) as data gets refreshed next month (next month data start from. Feb 2023 to July 2023) Table visualization has only Feb, mar, Apr, may, jun. Where in July 2023 is not added to table visual as the Column name got changed hence my visual Breakdown.
Need Help
•Can we achieve this by index
•Can we achieve this by dax with column7 is replaced by Apr 2023
•can we achieve this by power query dynamically
• is there any way to achieve this.
2 Replies
- lbendlinSuper User
Use a matrix visual
- AnonymousNot applicable
Hi lbendlin ,
Thanks for the quick response.
Hi R_K_Damera ,
May I ask if you have solved this problem?
If not, have look at this it is in DAX
https://m.youtube.com/watch?v=4emPkBiiCtg
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.