Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
By default Power BI arranged them in this format. I'd like to re-arrange them. How do I move column 1 before column 2 in the visual.
Column '90 Days or More' is column one - I'd like to re-arrange it to be in front of column '100 Days or More' which is column 2 in red. Once the re-arrangement is complete, they would list as followed:
90 Days or More || 100 Days or More || 130 Days or More
Thanks. Sakal
Solved! Go to Solution.
1) Create a Conditional column in Power Query (or new calculated column with Dax) where you define the order you desire: If [Field] = "90 Days or More" then 1 else if [Field] = "100 Days or More" then 2 else if [Field] = "130 Days or More" then 3 and name it like "Days Bucket Sorting"
2) Go to Table view and select the field/category column. Go to the upper Column tools menu and select Sort by column
3) Select the "Days Bucket Sorting" column from the dropdown list
Proud to be a Super User!
Hi! @Sakal
Once you select that visual you can see that information under visualisation, I believe it's a matrix, so you can move the fields by dragging. That order will define which column should be number 1,2 or 3.
1) Create a Conditional column in Power Query (or new calculated column with Dax) where you define the order you desire: If [Field] = "90 Days or More" then 1 else if [Field] = "100 Days or More" then 2 else if [Field] = "130 Days or More" then 3 and name it like "Days Bucket Sorting"
2) Go to Table view and select the field/category column. Go to the upper Column tools menu and select Sort by column
3) Select the "Days Bucket Sorting" column from the dropdown list
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
130 | |
80 | |
53 | |
38 | |
35 |
User | Count |
---|---|
207 | |
82 | |
75 | |
55 | |
50 |