Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Presenting Matrix in Sequential Order

I have a matrix that returns data for a trailing 13 months. I need that data to show sequentally (December2016, January2017, Feburary2017...) instead of alphabrtically. Does that function exsist in power bi? 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Do you use "Connect Live" mode to connect to SSAS database in Power BI Desktop?  In this case, sort by column is grayed out, and you need to sort the column in your original data source.

    Regards,
    Lydia

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you but my Sort By Column selection in my Modeling interface is grayed out. How do change that so that I may sort accordingly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

        Do you use "Connect Live" mode to connect to SSAS database in Power BI Desktop?  In this case, sort by column is grayed out, and you need to sort the column in your original data source.

        Regards,
        Lydia