Forum Discussion

knutsonbioag's avatar
knutsonbioag
Regular Visitor
1 year ago
Solved

Multi Level Column Headers

Can you create a report that has multiple table headers?  IE Fiscal Year with Category under that.  Or how do you show multi FY sales under a category.  
Need Help
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi knutsonbioag,

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    Thank you Elena_Kalina, for your valuable insights.

    You can create a report with multiple column headers like Fiscal Year > Category using the Matrix visual in Power BI. You can drag Fiscal Year and then Category into the Columns field of the Matrix, and your sales measure into Values.

    Create a matrix visual in Power BI - Power BI | Microsoft Learn

     

    If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you.

Elena_Kalina's avatar
Elena_Kalina
Solution Sage
1 year ago

Hi knutsonbioag 

Perhaps I do not quite understand what exactly you are looking for. But in my opinion, the matrix can help you. If you meant something else, then please show at least schematically what you want me to help you

        

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

 

 

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
1 year ago

Hi knutsonbioag,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Thank you Elena_Kalina, for your valuable insights.

You can create a report with multiple column headers like Fiscal Year > Category using the Matrix visual in Power BI. You can drag Fiscal Year and then Category into the Columns field of the Matrix, and your sales measure into Values.

Create a matrix visual in Power BI - Power BI | Microsoft Learn

 

If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

 

Thank you.