Forum Discussion
To change the column Headers dynamically in table visual
Hi All,
I'm trying to change the column headers dynamically in the table visual.
I have a lot of columns like the normal ones... Some are the columns that contain the label name, which changes dynamically through BusinessId.
For example :
In the place of (Headers) FirstValueA , SecondValueB, ThirdValueC, and FourthValueD,
the values that are contained under Custom Label A,B, C, and D should change accordingly to the businessId
Expected Output:
for BusinessId 1
For BusinessId 2
For BusinessId 3
and if none of the business IDs are selected, the header should display CustomLabel 1, CustomLabel 2, CustomLabel 3, and CustomLabel 4 for those fields.
I tried using unpivot but couldn't achieve the expected output.
Any help would be much appreciated.
Thank You!
amitchandak Greg_Deckler lbendlin Anonymous Ashish_Mathur FreemanZ tamerj1 collinq