Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Keep Columns Permanent in Matrix

Hello! I have a matrix with test and control columns where our test group is subdivided into test A and test B. The calculations are perfect and filters work just fine. However, I would want to ke...
columns
DAX
matrix
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    According to your description, I create a sample.

    Here's my solution.

    1.Create a new slicer table like this.

    2.Make relationship between the two tables with the item column.

    3.Put the slicer column in the new table in the slicer, get the expected result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

According to your description, I create a sample.

Here's my solution.

1.Create a new slicer table like this.

2.Make relationship between the two tables with the item column.

3.Put the slicer column in the new table in the slicer, get the expected result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    v-yanjiang-msft , this is wonderful and works exactly as I wanted it to be! Thank you so much for the suggestion!