Forum Discussion

kkanukurthi's avatar
kkanukurthi
Helper III
1 year ago
Solved

Unable to sort Matrix visual column values while clicking on column headers

Hi All, Need help on sorting Matrix column values ascending or descending. Values calculated by measure. Scenario I have a matrix visual in a Power BI report: Rows: "Category" column from the Ord...
Need Help
Show and Tell
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi kkanukurthi ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    In Table visual, It is not possbile to represent  Month-Year placed horizontally with categories in rows. And in Matrix visual, it is not possible  to sort the values under column headers.

     


    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thanks and Regards

v-dineshya's avatar
v-dineshya
Community Support
1 year ago

Hi kkanukurthi ,

Thanks for reaching out to the Microsoft fabric community forum. 

 

In Matrix visual, it is not possible  to sort the values under column headers. You can acheive your requirement in Table visual. Please replace Matrix visual with Table visual.

 

Please refer the sample pbix file.

 

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

kkanukurthi's avatar
kkanukurthi
Helper III
1 year ago

Hi v-dineshya ,

In Table visual we cant achieve the same output. I have tried with Table visual but not able to split the measure values horizontally every cell. I need Month-Year placed horizontally with categories in rows and ship date values with little triangle icon same as below.

 

 

Thanks in advance 🙂

 

 

 

  • v-dineshya's avatar
    v-dineshya
    Community Support
    1 year ago

    Hi kkanukurthi ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    In Table visual, It is not possbile to represent  Month-Year placed horizontally with categories in rows. And in Matrix visual, it is not possible  to sort the values under column headers.

     


    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thanks and Regards

    • v-dineshya's avatar
      v-dineshya
      Community Support
      1 year ago

      Hi kkanukurthi ,

      If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
      Thanks and Regards

    • v-dineshya's avatar
      v-dineshya
      Community Support
      1 year ago

      Hi kkanukurthi ,

      If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
      Thanks and Regards

      • v-dineshya's avatar
        v-dineshya
        Community Support
        1 year ago

        Hi kkanukurthi ,

        If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
        Thanks and Regards