Matrix currently doesn't allow you to sort the columns based on designating values as being a priority above the column field names. For example, my field in the columns section results in three co...
Jeff_Masse
5 years agoNew Member
While not a direct solution, there is a simple workaround to this problem, it requires just two steps: 1. Create a new column in your table called "Sort Order". This columns needs to map 1:1 to the original column. This Sort By column should be in ascending order in the order you want your original column to be ordered. 2. Use Power BI's "Sort by" feature to sort your original column by the new "Sort Order" column you just created. For example, if you had Year in the columns of a matrix. You could get them in descending order by creating a new column Sort Order = -Year. Then use the Sort By feature in Power BI to sort Year by your new Sort Order column.
Recent ideas
Allow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels3 hours agoAdvocate IIINew179Views0likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen4 hours agoAdvocate INew293Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi4 hours agoMicrosoft EmployeeNew18Views6likes0Comments