Forum Discussion

Biome's avatar
Biome
New Member
2 years ago

Group columns by values in a matrix

Hello,

I have been trying to find a solution to this for a long time.

Is there any way to be able to sort the columns inside a matrix? In some cases, when using dates as columns, I would like to be able to group the data by value type instead of having the different values mixed within each day.

I attach an image to make it much clearer.


Is there any way to do that easily?

Thank you very much

 

Need Help

6 Replies

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Biome 

    For Sort Column
    Yes please create a column for sort https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop

     

    In matrix visual, there are drill down button. Please use the drill down button to group 

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

    • Biome's avatar
      Biome
      New Member
      2 years ago

      Hello PijushRoy thank for your reply.

      I can't see that option when selecting the matrix. Maybe I should enable it first somehow?

      Thanks

      • PijushRoy's avatar
        PijushRoy
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Hi Biome 

        Can you please share a screenshot for which fields you enter in matrix Row, Column and Value