0 Kudos

Matrix visual not aggregating data when empty values in the row

Status: Needs Info
by VeraZ Visitor on ‎01-11-2018 01:31 AM

Hello Power BI community!

I've encountered an issue with the matrix visual: It doesn't aggregate data correctly and displays unnecessary empty cells.
Possible cause or correlation can be, I have a variable with empty values in the rows. But I am not sure.

My setup: several variable used as rows, one column variable, one value variable



In case there are values for all three rows variables: values data are correctly aggregated.
But in case there is no value for "Last Resolved Month" for a combination of other two variables, values are not aggregated and are split into several rows as shown below:


It doesn't matter if I use stepped layout or not.

Could you please advise, if I am doing something wrong or fix this issue?

Thank you!

Status: Needs Info
by Moderator v-qiuyu-msft
on ‎01-12-2018 01:14 AM

Hi @VeraZ,


Do you mean the red section rows should be aggregated in one row? 


Please share a sample pbix file which can reproduce the issue with us. You can upload to your OneDrive and send link to me in private message. 


Best Regards,
Qiuyun Yu 

by Vicky_Song Established Member
on ‎01-12-2018 01:15 AM
Status changed to: Needs Info
by asuajela Frequent Visitor
on ‎09-27-2018 08:04 AM
Good afternoon, I would like to ask you a question about matrix. When I create a matrix, the columns are shown in an order by default. I would like to know if there is an option to change the order of columns. Thanks for your soon reply.
Idea Statuses