Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi everyone, I am currently struggling with building the demanded tables in a PBI report.
The target visual is as follows. Top is calendar week, this filter is easy. Below is a data field that is entered for the respective week, which is also easy. However, how to I manage to make a table with only the calendar weeks on top and the values below with now "starting column" ? When I use the visual for "table" I cannot manage to get rows horizontally for calendar week, when I use "matrix" I cannot manage to produce a table without a starting column (marked as yellow).
Maybe one of you knows how to do this. Thank you very much!
Target (top part):
Output "Table"
Output "Matrix"
Data example:
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 90 | |
| 78 | |
| 66 | |
| 65 |