Forum Discussion
table data presentation
HI Anonymous
If so, you need to duplicate the basic data and transform it in duplicate table.
Then create the relationship by Name
Result:
and here is sample pbix file, please try it.
Regards,
Lin
Anonymous tranform the data in power query, copy following script and then use matrix visual to product the result
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSs5ILMrJTFXSUTI0NAKSRsaGSrE60UqpRZnJYK4JkDQ2MlKKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, col1_fd = _t, col2_rd = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"col1_fd", Int64.Type}, {"col2_rd", Int64.Type}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Name"}, "Attribute", "Value"),
#"Inserted Text After Delimiter" = Table.AddColumn(#"Unpivoted Other Columns", "col_tag", each Text.AfterDelimiter([Attribute], "_"), type text),
#"Added Custom" = Table.AddColumn(#"Inserted Text After Delimiter", "Name New", each ([Name]&" " &[col_tag]), type text),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Name", "col_tag"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Name New", "Name"}})
in
#"Renamed Columns"
Anonymous file attached, look at table (4) steps, there are other tables in the model, just ignore those
parry2k thankyou so much for your help. but I need to show both the tables (showing the same data but just in different format) in my report tab. so can i achieve this in dax or some other way so that i can show both the tables visuals through one data table only.
.
Regards,
Chahat
HI Anonymous
If so, you need to duplicate the basic data and transform it in duplicate table.
Then create the relationship by Name
Result:
and here is sample pbix file, please try it.
Regards,
Lin