Forum Discussion
Matrix table not displaying all the values
I am trying to use matrix table to create a table visualisation. However, it is only displaying 1 row of data at a time instead of all the data values.
This is my entire row of data that i want to display:
This is what it is showing. Only 1 line and I dont have the option to select "Don't Summarize"
How can i display all the values? Please help me thank you.
7 Replies
Hi TAN_THOMAS - As suggested by VahidDM - If you want to display all the values you can change it to table chart.
if you are looking for matrix visualization, instead of placing the column1 in Column tab, please it in Row tab, you can see both the value1 and value2 with aggregated column2.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Hey TAN_THOMAS
you need to use a table visual and write two measures for V1 and V2 and use them in your table.
Can't do that with Matrix
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
VahidDM
What measure to write? Can you provide me an example of how i can display the data in a table form using measure?I need Value 1 and Value 2 to be the row header and the numerical values to be the column values. Using the table will result in Value1 and Value2 being displayed as a long list of rows and the respective values to it. I want Value 1 and Value 2 to be the row header and all the values as below the header
in that case, follow rajendraongole1 instruction to add those as row title
All dimensions added to the value tile must be aggregated one way or another and are evaluated based on the intersection of rows and columns. The matrix visual doesnt know which row in Value 1 is the equivalent in Value2. The same thing happens if you do it in a pivot table in Excel. Your table should look something like below to be able split the values into rows:
The number columns goes to the row tile.
