Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

2-level sort capabilities

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.
Status: Needs Votes
Comments
gfletcher2
New Member
Yes, Please add secondary sort to the Table Visualization!
rusd_robc
Advocate I
I need this as well.
raynokellerman
New Member
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.
fbcideas_migusr
New Member
Status changed to: Needs Votes