Forum Discussion

GowthamK66's avatar
GowthamK66
Frequent Visitor
1 year ago
Solved

How to create this table(Transpose)

Expectation: all the table measures will be in row-wise below the metrics column, so how we can do this the data source is in the SSMS server L4 is Last four week, L13,L26,L52 Should come as each co...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi GowthamK66 


    Please try this:

    Here I have the sample data:

    You can create a matrix and put the category column on the Columns box:

     

    And open the Switch values in row groups rather that columns:

    The result is as follow:

     

    And here's another workaround:

    Add a new table:

     

     

    Table 2 = {"Measure1","Measure2","Measure3"}

     

     

    Then add a new measure:

     

     

    Measure = 
    VAR _Values = SELECTEDVALUE('Table 2'[Value])
    RETURN 
    SWITCH(
        _Values,
        "Measure1",[Measure1],
        "Measure2",[Measure2],
        "Measure3",[Measure3]
    )

     

     

    Finally, create a matrix with these fields:

    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.