Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Add multiple column headers to matrix or table visual

Hi, I need to create a powerbi visual that can be exported to excel in the same format as the current template which is used for an upload to the cloud. I am having trouble adding the required data to the visual and am not sure it is possible - this is what i need the header of the table to look like but I can only get one row to display in powerbi:

 

Is this possible or does anyone have a potential workaround?

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    That's not what Power BI is for. DAX queries fundamentally return tables.  You can experiment with ROLLUPADDISSUBTOTAL and other exotic stuff but it will be easier to do the templat-y stuff elsewhere, like in Excel.