The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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: