Forum Discussion

kongyuancn's avatar
kongyuancn
Helper II
2 years ago
Solved

Dynamically switch row and column in matrix

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:

idx-axisy-axis
1plot_aplot_b
2plot_bplot_a

 

 

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

 plot_a
plot_bVALUE_1

           

 

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

 plot_b
plot_aVALUE_2

 

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

 

Thanks in advance

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.