Excel already does this well... Our example: We have a client with monthly data (Revenue, Target, Prior Year...) for various products. We want to graph this data or display it in a table. The data must always be first sorted by month (Jan, Feb, Mar), but then we also want to sort by the values in one of the columns, e.g., Revenue, ascending or descending. Right now, the secondary sort is alphabetical, based on the product name.
4 Comments
- Yes, Please add secondary sort to the Table Visualization!
- I need this as well.
- Would be great, my example . . . . Either using the stacked column chart or clustered I would like to sort the following 1.) showing by months 2.) Total (sum) of categories, 8 different categories 3.) X-axis concatenate labels turn off Issue: As soon as I try sorting the Total( sum) category by (Asc) the x-axis concatenate turn off option breaks. In excel it works, I would like to see this working in power bi desktop/services Again, would be great.
- Status added:Needs Votes
