Forum Discussion

ilcaa72's avatar
ilcaa72
Helper IV
7 years ago
Solved

matrix table help

hello,  i am trying to create this matrix in this format, a Dimension in column 1 that is distinct, and in Column 2, a set of repeating measures for each distinct Dimension in Column 1.  If possible... i would like each value cell  to link to another report page...

 

i am enclosing a screenshot, i tried to do this in the standard matrix but had trouble... please give me advice .  thanks

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    ilcaa72,

    It is not possible to link each cell value to other report page as you describe, there is a similar idea about this issue, please vote it up. 

    In addition, to show measures in rows of Matrix visual, you would need to create a disconnect table as described in this blog.

    Regards,
    Lydia

5 Replies

  • th3h0bb5's avatar
    th3h0bb5
    Resolver II
    7 years ago

    It's not an exact representation (it's pivoted) but you can make something similar using a table viz and a slicer:

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    ilcaa72,

    It is not possible to link each cell value to other report page as you describe, there is a similar idea about this issue, please vote it up. 

    In addition, to show measures in rows of Matrix visual, you would need to create a disconnect table as described in this blog.

    Regards,
    Lydia

    • ilcaa72's avatar
      ilcaa72
      Helper IV
      7 years ago

      thanks Lydia.  The link to report is the least of the concerns, its a "nice to have". 

       

      the ideal would be to create this type of structured table. ill check out the links

    • ilcaa72's avatar
      ilcaa72
      Helper IV
      7 years ago

      question Lydia

       

      do you think i will be able to drop a Dimension in 1st column like my original screenshot shows?  (if you have used this before)

       

      i just dont want to go thru the process and I cant format it this way... any guidance on this issue?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        ilcaa72,

        I am afraid that it is not possible as if you add the dimension to the Measure table, how will you establish relationship between the measures based on the dimension?

        Regards,
        Lydia