Total Pageviews

2022/01/13

[PowerBI] 自訂排序

Requirement

假設我希望 X 軸的學歷資料,能夠依高中、大學、碩士與博士的順序來進行排序


How-To

Step 1. 建立 Conditional Column


Step 2. 建立 Column 與 Value 的 Output 順序值

Step 3. 成功建立學歷排序規則

Step 4. 點選「學歷」=> Sort by column => 學歷排序規則

Step 5. Sort axis => 學歷

Step 6. 檢視結果







1 comment:

Nishant Saurabh said...


Excellent explanation! Clear, concise, and incredibly beginner-friendly. 🚀
If you're eager to explore more exciting power-bi-tutorials and deepen your understanding, don't miss this detailed guide:
👉 power-bi-tutorials – Explore What's New
Keep learning, keep coding, and keep growing! 💻✨