Matrix Report design

[Power_Bi_User12]

I am new to Power BI and started doing some POC's. I am trying to create Matrix report with below data.

I have data in the below format in Excel

Asset	Asset Status	QYear
Signal	On Hold	Q32022
Signal	On Hold	Q32023
Signal	On Hold	Q32022
Signal	Inprogress	Q32022
Signal	On Hold	Q32023
Signal	Inprogress	Q32023
Signal	Inprogress	Q42024
Signal	Inprogress	Q42024
Signal	Completed	Q12024
Signal	Completed	Q42024
Signal	Completed	Q42024
Signal	Completed	Q42024
Signal	Completed	Q12022
Comms	Completed	Q22022
Comms	Completed	Q32022
Comms	Completed	Q32022
Comms	Inprogress	Q32023
Comms	Inprogress	Q32023
Comms	Inprogress	Q32023
Comms	Inprogress	Q32023
Comms	On Hold	Q42024
Comms	Completed	Q12024
Comms	Completed	Q12024
Comms	Completed	Q12024

I need to show the report as below

Please help here.

[Anonymous · Accepted solution]

HI @Power_Bi_User12,

You can add a calculated column to use the text function 'LEFT' to extract the left 2 characters from the 'quarter year' field, then you can use it on the matrix column field to group your records:

Quarter =
LEFT ( Table[QYear], 2 )

LEFT function (DAX) - DAX | Microsoft Docs

Regards,

Moonlight

[lbendlin]

You need to add calculated columns for the row headers, use separate matrix visuals, or create a bunch of custom measures.