Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Multiple Tables into a Matrix

I created multiple tables which shows values for what happened yesterday and then the prior week. (See below). I was wondering if it was possible if I can create a Matrix which just has 2 columns (Yesterday and then Last Week). And then just having the 4 values in 1 matrix. Is that possible? The values are all using a created metrics I created. Or would I be able to create a summarized table to do this easily?

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    3 years ago

    Hi Anonymous ,

     

    If you add the values on a matrix you are abble to show them in the same table, you can do and auxiliary table with the following format:

     

     

     

    Then add a metric with the following code:

    Matrix Measure = SWITCH(SELECTEDVALUE('Table (2)'[ID]),
1, [Accounts Created Yesterday],
2, [Signins Yesterday],
3, [Accounts Created Yesterday],
4, [Signins Last Week]
)

     

    Result would be similar to the one below:

     or

     

    You can then format the table has you need in order to get the better look and feel

     

     

     

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi Anonymous ,

     

    If you add the values on a matrix you are abble to show them in the same table, you can do and auxiliary table with the following format:

     

     

     

    Then add a metric with the following code:

    Matrix Measure = SWITCH(SELECTEDVALUE('Table (2)'[ID]),
1, [Accounts Created Yesterday],
2, [Signins Yesterday],
3, [Accounts Created Yesterday],
4, [Signins Last Week]
)

     

    Result would be similar to the one below:

     or

     

    You can then format the table has you need in order to get the better look and feel