Forum Discussion
Group header for Table Columns
I have a table visual that displays various columns including 2020 - 2025. Is there a way to add a group coulmns heading encompassing the year columns similar to the below? I could add a text box, etc and positon above the coulmns, but wondered if anyone had any alternative solutions?
Hope that makes sense.
6 Replies
- Pragati11Super User
Hi StuartSmith ,
I don't think there is anyother way I can think of doing this.
You can add text box as you mentioned, you can also make the header dynamic with the combination of text box and card visuals with YEAR values in them.
Thanks,
Pragati
- timgSolution Sage
Hi Stuart,
This solution is a bit less customizable than the image reference you show in your post, but it would allow you to add a header directly into the visual.
- first, create a calculated column (e.g.: Header = "Header text")
- Then, use a matrix visual instead of the table visual, and place your new header in the columns, above the other columns (like year) and drill down to show all levels
- via the formatting tab you can change the layout of the new grouped column header somewhat (but like I mentioned before its a bit more limited than a text box)
Hope it helps!
Regards,
Tim
- Tahreem24Super User
Frankly speaking, there is no such feature available as of now. You can go ahead with your proposed idea using text box.
- StuartSmithPower Participant
Cheers guys/girls, I will take a look at your solutions, although as an after thought, the text box solution will only work if the table doesnt have a horitonal scroll as the text box would remain static, whilst the year columns would move.
- AnonymousNot applicable
Hi StuartSmith ,
To my knowledge, your requirement could not be realized currently.
But this is at idea/feedback level alone. May be , hopes Power Bi will implement this in nearby future.
If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback -
Table & Matrix : Extra header row to group headers (attributes and measures)
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - AnonymousNot applicable
Hi StuartSmith ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.
Best Regards,
Eyelyn Qin