Forum Discussion
Transpose Rows and Columns in Matrix
- 10 years ago
jahida Great answer jahida...As I was thinking through how to answer your question I untangled the problem. First, it's a visual I was struggling with. And several columns I was using were percentile metrics computed from a selection of "provider" records. This selection is not the same as the selection of providers I was looking to use as columns--so I was struggling to parse the values from that slicer to use as columns. Anyway, without getting too tangled up in describing the jumble I was in, your question had me just put the providers as columns...and that works great.
I was able to transpose data in a Matrix visualization by using the formatting options in the specific visualizations. Select Values>Show on Rows (slider)>ON.
Hope this helps...
Todd
Very helpful! Thank you!