Dynamically switch row and column in matrix

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.