Changing Column headers dynamically

[Nikhil_567]

Hello,

I have a requirement in which I need to change the column headers of matrix visual dynamically. Here is the situation-

I have a data table like below-

Data Source	Attribute 1	Attribute 2	Attribute 3
Azure	A		B
GBQ	P	Q	R

And I have prepared a matrix visual like below-

Metric	Attribute 1	Attribute 2	Attribute 3
Sales

Now, we have a slicer for Data Source and according to the selection of values of the source, the column headers of above matrix visual should dynamically change.

If I select GBQ from Data Source slicer, the column headers in below matrix visual should change like - Attribute 1 should become A and Attribute 2 should remain blank and Attribute 3 should change to B.

And If I select Azure from Data Source slicer, the column headers in below matrix visual should change like - Attribute 1 should become P and Attribute 2 should change to Q and Attribute 3 should change to R.

Suggestons please.

[v-zhengdxu-msft · Accepted solution]

Hi @Nikhil_567 

Please try this:

Click the Transform data > Select the Attribute(1,2,3) and click Unpivot columns in the Transform pane:

Close & Apply

The result is as follow:

Best Regards

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