Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Team,
Im trying to create report with table format.But in table columns having some parent headers (kind of grouping) as below.
Could you please suggest. Please suggest some workaround if there is no direct option.
Thank you,
Regards,
Karthik.K
Hi @karthiknpm,
In Power BI, it is not possible to add group headers.
As a workaround, you could unpivot table structure first in Query Editor mode. Then, add a calculated column to group original field names (which are listed in a new single column). Then, use a Matrix visual to display data.
Regards,
Yuliana Gu
Hi,
Thank for the response.
Currently I didnt pivoted the columns. all are columns in a table.for designing purpose I had grouped the columns.
Enclosed the screenshot of table structure.
Could you please provide a sample.
Note: Is there any option to remove column headers in table (not by changing background colour to same colour). By only view the rows .
Regards,
Karthik.K
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |