Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
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
You need to add calculated columns for the row headers, use separate matrix visuals, or create a bunch of custom measures.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |