Forum Discussion

taylororiger's avatar
taylororiger
Helper II
4 years ago
Solved

Need help with potential grouping?

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?

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

3 Replies

  • Syk's avatar
    Syk
    Resident Rockstar
    4 years ago

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

    • taylororiger's avatar
      taylororiger
      Helper II
      4 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.