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.

 

  • 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.

5 Replies

  • 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

      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.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support

    Hi knutsonbioag,

    I hope you had a chance to review the solution shared earlier. If it addressed your question, please consider accepting it as the solution — it helps others find answers more quickly.
    If you're still facing the issue, feel free to reply, and we’ll be happy to assist further.

     

    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support

    Hi knutsonbioag,

    checking in to see if your issue has been resolved. If the response provided was helpful, kindly mark it as the solution so that others with the same issue can benefit.
    Please let us know if you still need assistance.

    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support

    Hi knutsonbioag,

    We haven’t heard back from you in a while. If your issue has been resolved, please mark the relevant response as the solution to help fellow community members.
    If you still need support, Please let us know if you still need assistance.

     

    Thank you.