Forum Discussion
Helper IINeed help with potential grouping?
Hi taylororiger ,
I agree with Syk, Power BI doesn't support us to remove duplicates in table visual like "Group" function. So using matrix visual is a good workaround. I think you can add level columns in matrix rows and then use drill down/up function. You can turn off "Stepped layout" function in Row header to get result as you want.
My sample:
Result is as below.
If this reply still couldn't help you solve your problem, you can share a sample file with us and show us a screenshot with the result you want. This will make me easier to find the workaround.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIWould there be a way to do this without creating a matrix? It looks like the rest of my data does not display correctly with a matrix.
Hi taylororiger ,
I agree with Syk, Power BI doesn't support us to remove duplicates in table visual like "Group" function. So using matrix visual is a good workaround. I think you can add level columns in matrix rows and then use drill down/up function. You can turn off "Stepped layout" function in Row header to get result as you want.
My sample:
Result is as below.
If this reply still couldn't help you solve your problem, you can share a sample file with us and show us a screenshot with the result you want. This will make me easier to find the workaround.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.