Forum Discussion
Help with Power BI Report builder - Matrix Layout
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
2 Replies
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/4773087#M1422149
If you get stuck, please provide sample data that can be copied and we could try figuring it out.
Hope it helps!
