Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |