Forum Discussion
Column Header Grouping problems
Hi usernamen ,
On the file you shared I was able to replicate the table at first attempt no problem. But I believe I was able to identify your issue.
The question is about the order of the columns on you image you present header and then group:
If I do that I do not get the proper result:
If i change the order of the two columns then I get the result you want:
Before drill down
After drill down
I believe that is your problem, in this case the Header is the column you want to have at the lowest level while the group refers to the aggregation of those values:
Has you can see the Group column is repeated for each hearder value.
Hi Felix,
thank you for your answer. Here you can download the file: PBIX It is not my file, it was just an example I found, doing exactly what I want to see. When I now rebuild the matrix in this file (see above), it doesn't work. I guess the problem there, is the same problem I have with the original data to get the columns properly grouped.
Thank you
Hi usernamen ,
On the file you shared I was able to replicate the table at first attempt no problem. But I believe I was able to identify your issue.
The question is about the order of the columns on you image you present header and then group:
If I do that I do not get the proper result:
If i change the order of the two columns then I get the result you want:
Before drill down
After drill down
I believe that is your problem, in this case the Header is the column you want to have at the lowest level while the group refers to the aggregation of those values:
Has you can see the Group column is repeated for each hearder value.
Hi usernamen
Could you please share the PBIX file in which you are trying to rebuild the matrix? Since the file you provided is an example that works correctly, having the PBIX you are working on will help us better understand and solve the issue.
Thank you.