Columns duplications in matrix table

[Anonymous]

Hi all,

I faced with issue of matrix table - I have this Data Set:

I created a matrix table with rows that include the "release" & "task" parameters, the rest of the parameters are in the column and the value (as the picture below):

In the picture, we can see there are duplications in the columns - due to that - this is not my desirable result.

My desriable result suppsed to be like in the picture below (remove columns duplications):

There is option to display it like in the picture above? if yes how I supposed to do it?

Thanks in advance!

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to your description. I did the test with the following reference:

The specific colors and lines can be set in the Format.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous See if this helps: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[Anonymous]

Hi @Greg_Deckler , thanks for the quick replay - I don't understand how you created the hierarchy in the Dax.
could you please explain it?

Thank you!