Forum

In a Matrix table w...
 
Notifications
Clear all

In a Matrix table with Team & Subteam categories, Team data appears on the next line

3 Posts
2 Users
0 Reactions
94 Views
(@markjames240)
Posts: 27
Trusted Member
Topic starter
 

Dear Forum,

I have built a matrix type table in PBID from an Excel table data source, to display monthly performance scores based on Teams and 'SubTeams'. The 'SubTeams' scores are properly aligned to their row headings, whilst 'Team' scores appear on the next row.

My raw Excel data and BI matrix are attached.

Please help me to get the Team data in the correct row.

Apart from that, the data are correct, and the table is basically how I want it to be.

Thanks again!

Mark James.Teams-Sub-Teams-Monthly-Score-Card-RAW.jpgTeams-Sub-Teams-Monthly-Score-Card-BI.jpg

 
Posted : 17/11/2018 1:38 am
(@markjames240)
Posts: 27
Trusted Member
Topic starter
 

Wait - I see the problem already DOH!

I have blanks in my SubTeam column, corresponding with the overall Team name.Perhaps I should replace the blanks with something like 'Combined'?

Mark.

<< Something like this? Teams-Sub-Teams-Monthly-Score-Card2-BI-1.jpg

 
Posted : 17/11/2018 2:07 am
(@mynda)
Posts: 4761
Member Admin
 

Glad you figured it out, Mark 🙂

 
Posted : 17/11/2018 8:04 am
Share: