Sort setting is NOT working for the grid chart when have a dimension in the Rows - Dashboard designer RRS feed

  • Question

  • Hi Everyone,

    Why the Sort option in the Grid chart is not working when you have a dimension in the Rows and a Measure in the columns?

    Is there any solution for that, because I need to have a Pie chart that can be changed to a grid chart, but I have realized that is the Sorting feature isn't working (it is producing a query error) when the chart has a dimension in the series or in the rows.

    So, I am wondering if anyone was able to solve this.


    Thanks in advance and best regards,


    Tuesday, April 26, 2011 4:44 PM

All replies

  • Joss,

    You should be able to have a Dimension in the rows and Measures in the columns.  What kind of error are you receiving?  The query that gets created, can you run it successfully in SSAS?


    If you could provide more information, this would be helpful


    Heidi Tr - MSFT

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Friday, April 29, 2011 2:22 PM