Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
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.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |