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
Control Schedule Activation per Environment in Deployment Pipelines
Currently, with the new multiple scheduler feature, we can define multiple run schedules for a Fabric item. However, when using deployment pipelines, there’s no way to control which schedules are act...frithjof_v1 hour agoCommunity ChampionPlanned5.7KViews65likes12CommentsFabric Mirroring for Oracle fails on unconstrained NUMBER columns
Hi, might there be a way to Mirror Oracle database to Fabric when tabels include unconstrained NUMBER columns by setting preconditions for those as it common for Oracle databases? BR, MagnusMagnusBerglund15 hours agoNew MemberNew20Views0likes0CommentsEmbedded Power BI: allow 12/24-hour clock setting independent of formatLocale
Problem In Power BI embedded reports (app-owns-data, JavaScript SDK), localeSettings.formatLocale is the only way to influence date and time display. The hour cycle (12 or 24 hour) is tied to th...VijaySama5881 day agoNew MemberNew6Views0likes0CommentsAdd Initial Horizontal Scroll Position to Matrix and Table Visuals
Please add an option to Power BI Matrix and Table visuals that allows report developers to configure the initial horizontal scroll position when the visual loads. Suggested setting: Format visual >...Panteras011 day agoFrequent VisitorNew3Views0likes0CommentsFabric Mirroring (and all artifacts) - Reassign owner
Probelm: I have users who have created Mirroring from Azure SQL DB's (although this problem exists with all mirroring) and if they dont log into fabric often the mirroring breaks. While best prat...Jreed_74741 day agoNew MemberNew121Views1like1Comment