Forum Discussion
MaleneL
1 year agoResolver I
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 ...
- 1 year ago
alish_b
1 year agoSuper User
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!