If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity
250 Comments
- Pavan6New MemberThis feature is very much required
- frederico_alme1New MemberWould be really Nice. I need to sort by Company and Year
- PointyStickRegular VisitorNeed to order by store, date. Very much needed feature.
- darren_donhardtNew MemberYes please, do add. Looking at migrating functionality from COGNOS impromptu to Power BI Desktop and this is important
- stewart_hunter1New MemberTotally agree. The 'solution' of creating a calculated column and sorting by that (similar with joining using multiple columns) is not really good enough.
- holly_jahangiriNew MemberThere are many very BASIC features that are not supported by Power BI. This is one of them. I don't think we should even have to vote on something this simple and straightforward - it's a feature of Excel.
- amin_hussaniNew MemberI agree with other comment, at least excel features should be part of Power BI.
- caantjesFrequent VisitorI have several reports created where it would be nice to sort on multiple columns. For example (1) number of orders decreasing year and month or (2) seqenced by weeks the number of tickets for each department in decreasing volume. Part of this want is that the multi column sort is very flexible in MS Excel
- allen_delaneyNew MemberCompound sorting seems like a very basic reporting feature. I would hope it would be added ASAP.
- ajuzaNew MemberAgreed, this is especially frustrating with the Table visualization (which I think you are referring to), considering that the data sources, if written in SQL, cannot contain an ORDER BY clause. The Power BI support team confirmed that this multi-level sort isn't available at this time in Power BI, but it is an essential need for reports that provide raw data output. SSRS has this out of the box, Power BI should as well. It should work just like Excel, for column data in a table, (i.e. sort by Column B Asc, then Column C Desc, then Column A Asc, etc).
Recent ideas
Improve Relationship UI Wording to Better Reflect Filter Propagation Direction
The current relationship dialog can be confusing because the UI labels "From" and "To" do not always align with users' linguistic expectations regarding filter propagation. As per document : Relation...v-varunvv16 minutes agoMicrosoft EmployeeNew2Views1like0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db32 minutes agoNew MemberNew223Views2likes1CommentTenant and/or App/Workspace Banner messages- alerts
As a tenant admin - would like to publish banner messages or alerts as needed for the organization in the event of a data load failure, or other messaging that needs to be show to the end user on l...sue_yerly56 minutes agoNew MemberNew378Views18likes3CommentsSlicer option to show no data when no value is selected
Hello Power BI Team, Description: Currently, when the "Select All" option is enabled in a slicer, selecting it displays all related values as expected. However, when "Select All" is de-selected and...7407543 hours agoNew MemberNew3Views0likes0CommentsParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v5 hours agoCommunity ChampionNew16Views1like0Comments