Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey Folks,
Hopefully a simple question, but is it possible for users to sort individual columns in a matrix? In this use case we would like to sort by the most orders per row for February, but we are only able to sort by the all-up total for the months in time period. Clicking the column only selects it and does not offer sorting options.
Solved! Go to Solution.
Hi @KPerrySHI ,
You do need an custom column to order your columns, but with AS, you could not add any data for your report, the only solution is add the column in AS before you connect it with Power BI or I am afraid you could not custom sort your columns.
Regards,
Daniel He
Hi @KPerrySHI ,
Based on my research, you may refer to below link to custom sort matrix header:
https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/td-p/71572
Regards,
Daniel He
Sadly, we connect to an Analysis Service which limits our abilities to manipulate the source data, and we can't access the Sort by Column options in the ribbon.
Was hoping there would be additional options in the visual, but I appreciate the help.
Hi @KPerrySHI ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi @KPerrySHI ,
You do need an custom column to order your columns, but with AS, you could not add any data for your report, the only solution is add the column in AS before you connect it with Power BI or I am afraid you could not custom sort your columns.
Regards,
Daniel He
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |