jenm on 05 Jan 2016 09:31:11
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.
- Comments (3)
RE: 2-level sort capabilities
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.
RE: 2-level sort capabilities
I need this as well.
RE: 2-level sort capabilities
Yes, Please add secondary sort to the Table Visualization!