Dynamically switch row and column in matrix

[kongyuancn]

Hello Sir,

I want to know is it possible to dynamically switch row and column in Matrix?

For example I've a small table defined how to display in matrix:

id	x-axis	y-axis
1	plot_a	plot_b
2	plot_b	plot_a

when I show data for id=1 the matrix looks like this:

	plot_a
plot_b	VALUE_1

when I show data for id=2 the matrix looks like this:

	plot_b
plot_a	VALUE_2

Can field parameter can handle this? Or there are other magic?

Thanks in advance

[Anonymous · Accepted solution]

Hi, @kongyuancn 

Thanks for the reply from @bhanu_gautam , please allow me to provide addition:

Based on your information, I create a sample table:

Create a field parameter with `x-axis` and `y-axis`.

In table view, uncheck the option to hide in report view

Then create matrix and put parameter and parameter field in matrix. Also create a slicer and put ID in it.

Select slicer to change value:

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[kongyuancn]

Thanks @Anonymous , this is exact what I need!

[bhanu_gautam]

@kongyuancn , Try using below method

Create Parameter Table:
Axis Parameter = {
("Plot A", "plot_a"),
("Plot B", "plot_b")
}
Add Slicer:

Drag the "Axis Parameter" to the slicer.
Matrix Setup:

Drag "Axis Parameter" to the Rows or Columns field well.
Add your measure (e.g., VALUE_1 or VALUE_2) to the Values field well.