matrix table help

[ilcaa72]

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

 

[Anonymous · Accepted solution]

@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]

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]

@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

[ilcaa72]

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

[th3h0bb5]

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