Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Visual looking like table, each cell has different measures and filters

Hi, 

is it possible to make a visual, table, like in excel, where I could put in each cell different value(measure)? If not, I will make the visual from 15 cards, but it would be much more user friendly, if the dat would be in a table.

Thank you. 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Anonymous Sure, you could do this by using a couple disconnected tables. For example, a table containing 1-5 used for columns and a table containing 1-3 used for rows. We'll call these Columns and Rows tables and let's say they both have a column called Column that contains the numbers. You create a matrix table putting Columns[Column] in Columns and Rows[Column] in Rows. Then you create a measure similar to this:

    Measure to Show =
  VAR __Row = MAX('Rows'[Column])
  VAR __Column = MAX('Columns'[Column])
  VAR __Result = 
  SWITCH( __Row ,
    1,
        SWITCH( __Column,
             1, [Measure 1],
             2, [Measure 2],
             3, [Measure 3],
             4, [Measure 4],
             5, [Measure 5]
        ),
    2,
        SWITCH( __Column,
             1, [Measure 6],
             2, [Measure 7],
             3, [Measure 8],
             4, [Measure 9],
             5, [Measure 10]
        ),
    3,
        SWITCH( __Column,
             1, [Measure 11],
             2, [Measure 12],
             3, [Measure 13],
             4, [Measure 14],
             5, [Measure 15]
        ),
  )
RETURN
  __Result
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Greg, 

       

      thank you, that sounds interesting! I didnt quite get the 

      VAR __Row = MAX('Rows'[Column])
  VAR __Column = MAX('Columns'[Column])

       

      What do I put i these tables? 

       

      For now I have this: 

      The categories are just text, light blue cards are each one measure (except for ACT, those are just columns from a table). I will have 16 rows, each with 7 columns. (The data model is 5 tables connected through date table). 

      Thank you :).