Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have one table in that table i have four column
Column Id
Column Sales
Column Profit
Column Period
Filter-Reporting Period
Using matrix chart I put the following column
Rows=Id
Columns=Period
Values=Sales,Profit
Original Data
Id Sales Profit Period Reporting Period
1 10 101 2013 18-Mar
1 20 201 2014 18-Apr
1 30 301 2015
1 40 401 2016
2 50 501 2017
3 60 601 2018
Expected Output
Id Sales 2013 2014 2015 2016 2017 2018 Reprting Period
1 10 101 201 301 401 - - 18-Apr
Current Output
Id Sales 2013 2014 2015 2016 2017 2018 Reprting Period
1 10 101 201 301 401 - - 18-Apr
20
30
40
Hi @Priyak,
It seems like matrix works on my side, can you please share a sample pbix file which can reproduce your issue?
Regards,
Xiaoxin Sheng
Hi,
Thanks for the reply but if you see desired output is not samethere are blank values in the Id 2 and 3 for 2017 and 2018 data is coming in seperate row we would like to merge them with the 2017 and 22018 with ID 1 so that we get all the data in one single row and column in not coming under Years header.
Request you to please us with the same.
Hi @Anonymous,
You can drag sales column to rows field, then drill row to bottom level, then your records will summary with id, sales as category label.
Regards,
Xiaoxin Sheng
Can we add measure into the row of the matrix becuase i am not able to do the same.
Hi @Anonymous,
Nope, measure can't use on row fields as category label.
Regards,
Xiaoxin Sheng