Matrix table not displaying all the values

[TAN_THOMAS]

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. 

[danextian]

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.

[rajendraongole1]

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!!

[VahidDM]

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!! 

LinkedIn|Twitter|Blog |YouTube 

[TAN_THOMAS]

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 

[rajendraongole1]

Hi @TAN_THOMAS - You can acheive this in power query editor as below steps:

Create an index column in table, Next do a pivot by selecting the Column1 and you can see the below snapshot for pivot column choose the below configuration and output you will see as expected row header with Value 1 and value 2.

final result should be as follows:

Once you achieve the output you can remove the index column if it is not required.

Advanced query output:

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkvMKU01VNJRMjQwUIrVIUnAwpJUHcZoOkwJajBB5aNxTc0I6DcxQBYxAooYYYiYmKLyDTG0GBNQgCFgSkgBYQGCrjIGKogFAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", Int64.Type}}),
AddedIndex = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type),
PivotedTable = Table.Pivot(AddedIndex, List.Distinct(AddedIndex[Column1]), "Column1", "Column2", List.Max)
in
PivotedTable

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[VahidDM]

in that case, follow @rajendraongole1 instruction to add those as row title

[TAN_THOMAS]

@VahidDM 
What measure to write? Can you provide me an example of how i can display the data in a table form using measure?