Forum Discussion
Is it possible to create a matrix view table using power query or dax ??
i would like to know that, is there any possibility to create a matrix view table using power query or dax which looks like below image link.
sample data
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCnYKNVTSUXLxBZEBEDIIRPr7AYmg1DKFgKL8rNTkEiAPJOyoFKuDocsIrAtE+ru5YdXmhKoNrMHXGKzNBGaZc35xCZo2Z2zaTMDaTOG2YdHnohQbCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [SBU = _t, DM = _t, PM = _t, PROJECT = _t, #"ON/OFF" = _t, #"Project Profile" = _t, FTE = _t, EmpName = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"SBU", type text}, {"DM", type text}, {"PM", type text}, {"PROJECT", type text}, {"ON/OFF", type text}, {"Project Profile", type text}, {"FTE", type number}, {"EmpName", type text}})
in
#"Changed Type"
Any Help Please.
Mohan.V
** I am unable to upload images...may i know why..
Hi Anonymous ,
By my tests, I'm afraid that we cannot achieve your desired table view in Power BI currently.
You may could achieve that view in Excel.
In Power BI, I'm afraid that we only could use Matrix visual to achieve that.
Best Regards,
Cherry
6 Replies
Anonymous yes this can be done, you need to share sample data using excel.
Thanks for the reply parry2k .
you can use that power query which i have shared.
the data i am working on, it is same as that.
here is excel file.
Anonymous solution attached.
Thanks for the solution parry2k .
But i was looking for a table where the data is as in the image that i have attached i.e matrix view.
I would like to have the data in my table as we see in matrix view.
I am not interested to use matrix visual here, but i want the data in my table as it looks like in matrix visual.
Please help.
Mohan V.
