Forum Discussion

mbacicci's avatar
mbacicci
Helper I
2 years ago
Solved

Table visualization sort by a column which is not total

Hi,

I could I sort (and allow users to sort) by a specific column instead of the total?

The table has customers and invoiced amount by month, I'd like to sort by a specific month.

Thank you!

 

 

CutomersJanuaryFebruaryMarchTotal
A541120
B64818
C1225
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mbacicci ,
    As per your description, we tried trying to sort the values in Columns aka Date in the power bi matrix visual object, which is not possible. As you have given the screenshot, date as column header is the value in date and we are not able to sort the values on the visual object. As an alternative, you can display what you want by using filters. Or use freez row headers to have a fixed view of it.


    How to freeze columns in a matrix/table in Power BI? - PowerBI Talks

     

    Best regards,

    Albert He

     

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

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    mbacicci  As long as your invoice amounts are not text values, e.g. are whole number or decimal, you should be able to click on the ellipsis and sort by month.

     



     

    • mbacicci's avatar
      mbacicci
      Helper I
      2 years ago

      Thank you!

      I don't know why I can't see it in there.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        mbacicci  Working with the data you provided, I placed all the attributes in the Columns section of a table viz. Can you share a snag of your visualizations pane?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi mbacicci ,
    As per your description, we tried trying to sort the values in Columns aka Date in the power bi matrix visual object, which is not possible. As you have given the screenshot, date as column header is the value in date and we are not able to sort the values on the visual object. As an alternative, you can display what you want by using filters. Or use freez row headers to have a fixed view of it.


    How to freeze columns in a matrix/table in Power BI? - PowerBI Talks

     

    Best regards,

    Albert He

     

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

     

    • mbacicci's avatar
      mbacicci
      Helper I
      2 years ago

      This is really interesting, I didn't know about it.

       

      Thank you - I believe this may help already to achieve the same scope. Unless there are better solutions.