Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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
Solved! Go to Solution.
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!
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 21 | |
| 17 | |
| 11 |
| User | Count |
|---|---|
| 58 | |
| 55 | |
| 43 | |
| 36 | |
| 35 |