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...
Need Help
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

    • Biome's avatar
      Biome
      New Member
      2 years ago

      This is what I have. 

       

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

        Hi Biome 

        Please check out view video - https://www.youtube.com/watch?v=0tVPLocU7e0

         


        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