Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Group value in Matrix

 

 

Hi All,

 

Is it possible to group data in a matrix like in Reporting Services.

When I use grouping under Power Bi, I get

 

When I use grouping under Reporting Services in matrix, I get:

Is it possible to get the same effect as in Reporting Services?

Need Help

8 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    Hi Anonymous 

     

    Based on my research, there’re only 2 displays accessible currently as below, which different with the one you requested.

    If you’d like bring your thought coming, you can put this idea in the portal, if people support it, dev team will take it into consideration.

    Link: https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Best regards,

    Dina Ye

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      How you created the first diagram?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Could You tell Me?

    • tex628's avatar
      tex628
      Community Champion
      7 years ago

      Matrix -> Format -> Row headers -> Stepped layout OFF

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Yes, I have it:

        But I still get:

        I think that's why there is a problem.

        but, why is it only First, Last or Count? Why can not I deselect it?

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      7 years ago

      Hi Anonymous 

       

       

      If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

       

      Best regards,

      Dina Ye