Forum Discussion

SittsBI's avatar
SittsBI
New Member
7 years ago

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 r...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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,

Cherry

 

SittsBI's avatar
SittsBI
New Member
7 years ago

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?