Help with Power BI Report builder - Matrix Layout

[MaleneL]

Hi all

I am working on a report in Power BI Report builder and I wondering if it is possible to build a matrix like this:

State	customer #	Name	Contact		2024	2023	2022
				Price	111	110	109
Alabama	XXX	SSS	VVV	Pieces	3	4	5
				Avg price	202	333	555
				Price	111	110	109
Alaska	XXX	SSS	VVV	Pieces	3	4	5
				Avg price	202	333	555
				Price	111	110	109
Texas	XXX	SSS	VVV	Pieces	3	4	5
				Avg price	202	333	555

I have only figured out how to build it like this

State	customer #	Name	Contact		2024			2023			2022
				Price	Pieces	Avg. Price	Price	Pieces	Avg. Price	Price	Pieces	Avg. Price
Alabama	XXX	SSS	VVV	111	2	222	111	2	222	111	2	222
Alaska	XXX	SSS	VVV	222	3	555	222	3	555	222	3	555
Texas	XXX	SSS	VVV	333	6	666	333	6	666	333	6	666

Which is not what I need

[MaleneL · Accepted solution]

found this one 
Report Builder: Paginated Reports - "Show on Rows"... - Microsoft Fabric Community

[alish_b]

Hi @MaleneL ,

It should be possible. But you will have to figure out the Tablix grouping first. Here is a good place to start (although you might need to go through other related articles too, Tablix is tricky when you are starting out): https://learn.microsoft.com/en-us/sql/reporting-services/tools/grouping-pane?view=sql-server-ver17

I added a screencast in this thread which briefly connects to the idea to show tablix abilities: https://community.fabric.microsoft.com/t5/Desktop/Paginated-Reports-Free-Layout-Within-Tablix/m-p/47...

If you get stuck, please provide sample data that can be copied and we could try figuring it out. 

Hope it helps!