Visualize sharepoint list as a matrix

[idra18]

Hi,

I need help visualizing a List into powerbi as a Matrix.

Is there a way to make my Sharepoint List 

 To be shown in PowerBI with the following format?

Thank you in advance.

[idra18]

Thanks @mlsx4 

[mlsx4 · Accepted solution]

Hi @idra18 

You must follow these steps:

1) When you import your Sharepoint list, you need to unpivot DMC, VAM and MPC. In this case:

let
    Origen = Excel.Workbook(File.Contents("C:\ex.xlsx"), null, true),
    Hoja1_Sheet = Origen{[Item="Hoja1",Kind="Sheet"]}[Data],
    #"Encabezados promovidos" = Table.PromoteHeaders(Hoja1_Sheet, [PromoteAllScalars=true]),
    #"Tipo cambiado" = Table.TransformColumnTypes(#"Encabezados promovidos",{{"Date", type date}, {"Xpoint", type text}, {"Target", type text}, {"DMC", Int64.Type}, {"VAM", Int64.Type}, {"MPC", Int64.Type}}),
    #"Columna de anulación de dinamización" = Table.UnpivotOtherColumns(#"Tipo cambiado", {"Date", "Xpoint", "Target"}, "Atributo", "Valor"),
    #"Columnas con nombre cambiado" = Table.RenameColumns(#"Columna de anulación de dinamización",{{"Atributo", "Category"}, {"Valor", "Value"}})
in
    #"Columnas con nombre cambiado"

To do it, you select the three columns and click on Transform >Unpivot (rename Attribute as Category)

2) Then, you should have a calendar table with Year, Month columns

3) You relate date with Calendar date field

4) Finally, you just create the matrix like this: