Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago

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

  • 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

  • timg's avatar
    timg
    Solution 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.

    1. first, create a calculated column (e.g.:  Header = "Header text")
    2. 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
    3. 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

  • StuartSmith ,

    Frankly speaking, there is no such feature available as of now. You can go ahead with your proposed idea using text box.

     

  • StuartSmith's avatar
    StuartSmith
    Power 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.

  • Anonymous's avatar
    Anonymous
    Not 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.

  • Anonymous's avatar
    Anonymous
    Not 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