Forum Discussion
How to hide duplicate hierarchy with same values in Matrix
I need to hide repeated data which is highlighted in the matrix below and show only a single one.
My data table is
Is there any way in powerBi to acheive this functionality? Any help is appreciated.
Expected Result:
Hi ChristaAlen ,
At present, the latest version of PowerBI desktop can only realize the hiding of empty rows in the hierarchy by creating a measure, and temporarily cannot realize the function you described. Because for the matrix, if the values of the first level and the second level after drilling are the same, but the values of the third level are different, when the same duplicate values are deleted, the values of the third level will also be deleted at the same time, destroying the matrix model . If you still want to fulfill your needs, you can post your idea here: Ideas - Microsoft Power BI Community
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-henryk-mstfCommunity Support
Hi ChristaAlen ,
At present, the latest version of PowerBI desktop can only realize the hiding of empty rows in the hierarchy by creating a measure, and temporarily cannot realize the function you described. Because for the matrix, if the values of the first level and the second level after drilling are the same, but the values of the third level are different, when the same duplicate values are deleted, the values of the third level will also be deleted at the same time, destroying the matrix model . If you still want to fulfill your needs, you can post your idea here: Ideas - Microsoft Power BI Community
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.