topic Re: Matrix Report design in Developer

Matrix Report design

Power_Bi_User12 — Thu, 04 Aug 2022 17:46:38 GMT

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.

Re: Matrix Report design

lbendlin — Fri, 05 Aug 2022 22:46:45 GMT

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

Re: Matrix Report design

Anonymous — Wed, 10 Aug 2022 07:15:32 GMT

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