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
Allow Workspace Admins to View Power BI Semantic Model Configuration Without Requiring Take Over
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Description As a Power BI Workspace Administrator, I understand why own...LeonardGreene1 hour agoNew MemberNew5Views0likes0CommentsOpen Fabric notebooks in View‑only by default
Problem: Developers and reviewers with edit permissions frequently open notebooks for reading. Notebooks currently open in edit mode with autosave, which causes accidental changes and noisy version h...AMD07912 hours agoAdvocate IVNew333Views11likes1CommentService principal authentication support for data sources in Paginated(RDL) reports
We are only seeing two options(Basic, OAuth2) for data source authentication in a paginated report, Recently we see that the Service principal authentication enabled for Power BI(PBIX) reports, simi...Thatikonda_Vams2 hours agoNew MemberNew133Views6likes2CommentsMetadata-Driven Copy Job Control at Table and Column Level
We currently achieve metadata-driven table and column selection in Copy Data activities by using dynamic queries. This allows us to dynamically determine which tables and columns should be processed ...Motasim097 hours agoNew MemberNew6Views0likes0CommentsDynamic ForEach Parallel Batch Count Based on Runtime Capacity
We would like Microsoft Fabric Data Factory to support dynamic configuration of the ForEach activity's parallel batch count at runtime. Currently, the ForEach batchCount is effectively configured as...Motasim097 hours agoNew MemberNew4Views0likes0Comments