Showing results for 
Search instead for 
Did you mean: 
SittsBI Frequent Visitor
Frequent Visitor

Issue with data display in the Matrix visual (unrequested data grouping)

Hi community,


I am trying to utilize the Matrix visual to create the table below, however, I am facing a serious issue. 

The data I'm analyzing is similar to the following:


The expected result I am trying to achieve is:


However, the actual result of such data set in the visual is:

PowerBI 3.png


The problem is that, by default, the visual group similar records (for example, if there are 2 supervisors in factory A, only one of them will be displayed). 

The only workaround I found so far is to add a drill-down for the "ID". The problem is that in this case, under the "supervisor", 4 lines will be displayed. When dealing with a large data set this is not a good result

Any ideas of how can I generate such a table or workaround the issue? 

Community Support Team
Community Support Team

Re: Issue with data display in the Matrix visual (unrequested data grouping)

Hi @SittsBI ,

By my tests and research, I'm afraid that we cannot achieve your desired output in Power BI currently.

For matrix, the value will be aggregated.

For workaround, you may try the matrix this format.


Best Regards,



Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SittsBI Frequent Visitor
Frequent Visitor

Re: Issue with data display in the Matrix visual (unrequested data grouping)

Hi Cherry, 


Thanks for the reply.

Unfortunately, this workaround is good only in small data sets. 

If I have 30 factories, and each one has 1-3 in the same rank, this will not be a good solution. 


Is there any other idea how to workaround this request?

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)