Forum Discussion

Benedikt_Sch's avatar
Benedikt_Sch
Icon for Helper I rankHelper I
3 years ago
Solved

Matrix order by Value over all columns

Hey,   I want to sort two colums (area and group) by qty sold in a Matrix. By default a matrix always sort a value by the first column (area). My users expect when drill down to area and group vie...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Benedikt_Sch ,

    Understand. Unfortunately I'm afraid it can't be achieved in a matrix. In a matrix, it has hierachy, Groups which has same Area can only placed besides, this will not be disrupted.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Benedikt_Sch's avatar
Benedikt_Sch
Icon for Helper I rankHelper I
3 years ago

v-yanjiang-msft achanikya  thank you for your replies.

I will try to make the problem more clear.

 

I have two columns and one measure.  My goal is to sort both columns by that measure in a matrix. 

 

If I use a table visual all is fine and Power BI consider both columns. 

But if i use a matrix-visual (my users need to expand / colapse)   Power BI only sort by Sum of Area. So Area 2 Group B (20 sales) ist ranked lower than Area A with Group B (5 sales). I do understand why Power BI sorting it this way. For most cases this ist the best behaviour. But not for my case right now. I wand a List ordered by QTY sold. No Matter whicht Area or Group if both is expanded.

 

 

 

If there is not option to get this in a matrix. I will try to work with tables and bookmarks

 

Benedikt

 

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Benedikt_Sch ,

    Understand. Unfortunately I'm afraid it can't be achieved in a matrix. In a matrix, it has hierachy, Groups which has same Area can only placed besides, this will not be disrupted.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Benedikt_Sch's avatar
      Benedikt_Sch
      Icon for Helper I rankHelper I
      3 years ago

      Thanks for the answer. I had already expected something like this.

      Maybe I can find another way to solve the problem.

       

      Best Regards

      Benedikt