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
Power Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes7 hours agoNew MemberNeed Clarification198Views3likes1CommentParameterize 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_v7 hours agoCommunity ChampionNeeds Votes36Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_7 hours agoNew MemberAbandoned25Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer9 hours agoAdvocate INew1.2KViews26likes2CommentsImprove relationship visualisation in Model View for large semantic models.
When working with complex models containing many fact and dimension tables, relationship lines frequently cross and overlap, making lineage difficult to follow. A useful enhancement would be to allo...jcheeseaos9 hours agoNew MemberNew12Views0likes0Comments