Need help with potential grouping?

[taylororiger]

Is there a way to show the Power Bi display as it is in the second screenshot?  There are names designated to each enagagement leader level, but I am curious if there is way to only list each engagement leader level once (as displayed in the 2nd screenshot) instead of repeatedly as in the 1st in Power Bi.  Not sure if this would be a use for the grouping feature and how that would be done?

[Syk]

You can use a matrix visual instead of a table. That may be the easiest fix.

[taylororiger]

Would 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.

[v-rzhou-msft · Accepted solution]

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.