Matrix visual not aggregating data when empty values in the row
Submitted byAnonymouson01-11-201801: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
Result: 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?