Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone, I'm trying to sort the following values to arrange the matrix with the SWITCH function to avail:
Sort = SWITCH('Merged Data'[Action], "Market", 1, "Region", 2, "National", 3, "Received", 4)
I'm trying to get the table to look like this:
Market
- No BOM Order Found
- BOM in Draft
- Pending Market Review
- Review Shortage
Region
- Pending Regional Review
- ...
- ...
- ...
National
- ...
Received
- ...
Anyone aware of a simpler way to sort rows/columns?
Many thanks!
Solved! Go to Solution.
You would need to create one of two things:
See this article for a more detailed overview of how to sort by another column rather than just alphabetically.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou would need to create one of two things:
See this article for a more detailed overview of how to sort by another column rather than just alphabetically.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |