Forum Discussion

bkanderso's avatar
bkanderso
Icon for Helper I rankHelper I
3 years ago

Having a problem with creating a report using a matrix template - Help!!!!

I have built a report using the matrix template in Power BI.  The report has all of the data (rows and columns) but I am having a problem with the wat the report is displaying the columns. three coulmns that I want anchored.  The table I am showing is how I want my report to look.  The 2nd table is what I am getting using the Matrix template provided in Power BI.  Is there a way, or another template that I can use to achieve the look of the first table?

Company1st Shift Qual count 2nd Shift Qual Count

Company

Qual Count

Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
    Employee            Type               
        Qual Type               

 

 

 

Q-MonthMonth 0  Month 1  Month 2  Month 3  Month 4  Month 5  Month 6  Month 7  Month 8  Month 9  Month 10  Month 11  Month 12  
Unit1st Shift Qual count 2nd Shift Qual CountEmployee Qual Count1st Shift Qual count 2nd Shift Qual CountEmployee Qual Count1st Shift Qual count 2nd Shift Qual CountEmployee Qual Count1st Shift Qual count 2nd Shift Qual CountEmployee Qual Count1st Shift Qual count 2nd Shift Qual CountEmployee Qual Count1st Shift Qual count2nd Shift Qual CountEmployee Qual Count1st Shift Qual count2nd Shift Qual CountEmployee Qual Count1st Shift Qual count2nd Shift Qual CountEmployee Qual Count1st Shift Qual count2nd Shift Qual CountEmployee Qual Count1st Shift Qual count2nd Shift Qual CountEmployee Qual Count1st Shift Qual count2nd Shift Qual CountEmployee Qual Count1st Shift Qual count

   

2nd Shift Qual Count                       

Employee Qual Count1st Shift Qual count2nd Shift Qual Count Employee Qual Count
      Company                                        
Employee   Type                                       
     Qual           Type                                       

2 Replies