Forum Discussion

emma_3's avatar
emma_3
Regular Visitor
3 years ago

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 

2 Replies

  • hi emma_3 

     

    I dont think the column header could be customized, but one way to achieve the same is using Bookmarks, so that once the business id is selected, the same table with different column names can be shown on top of other.

     

    Hope this helps!

    alekh