Is it possible to create a matrix view table using power query or dax ??

[Anonymous]

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.

Look at this image

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

[parry2k]

@Anonymous yes this can be done, you need to share sample data using excel.

[parry2k]

@Anonymous solution attached.

[Anonymous]

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.

[v-piga-msft · Accepted solution]

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

[parry2k]

@Anonymous sorry misunderstood your requirement, seems like you want to transform the datain the matrix view correct? Can you show in excel how you want the data transformation should look like?

[Anonymous]

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.

https://1drv.ms/x/s!AhiQ2f7YQHC-gbNfO7LAUPdigAHYAA