Forum Discussion

R_K_Damera's avatar
R_K_Damera
Frequent Visitor
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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 _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.