none
How to sort Tile By in Power View

    Question

  • I am using the version of Power View that shipped with SQL Server 2012 SP1.  I am using it in a SharePoint 2013 farm.

    Is there a way to sort the entries that show up in the Tile By field?

    In other words, if I Tile a column chart by dropping Year into the Tile By field, I would like to be able to choose whether the Tile control shows the years in ascending or descending sequence from left to right.

    I can't find a way to make this happen.  Does anyone else have an idea?

    My data source is a PowerPivot data model, so I have complete control over the data.  I've tried specifying that the Year column should be sorted in descending sequence in the data model, but that has no effect on the sort in the Tile By in Power View.   It always sorts on ascending numeric sequence.

    Jeff Cate


    Jeff Cate, Founder and President, SharePoint Solutions

    Thursday, October 17, 2013 7:21 PM