Forum Discussion

Gopal_PV's avatar
Gopal_PV
Icon for Helper III rankHelper III
1 year ago
Solved

How sort Switch column values with other order column in power bi

Hi Friends, I have imported snowflake view in to Power bi. Now I have created new column using switch for Bucket list of units. Now i want to  order the same bucket list. I want to use same bucket f...
Tips and Tricks
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    - Create a lookup table with unique bucket names and order:
    - DIY → 1
    - Small → 2
    - Medium → 3
    - Enterprise → 4
    - DG Enterprise → 5


    - Fix naming in your SWITCH logic so it matches the lookup table exactly.


    - Sort the lookup table’s Units_Bucket column by Bucket_Order.


    - Use the lookup table’s Units_Bucket in your slicer for correct order and clean filtering.


    Let me know if you want a one-table workaround or multilingual slicer support too.

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

Without sample data, I can only suggest ot rewrite the column

Units_Bucket_Order =

SWITCH(
    TRUE(),
    -- Non-DG buckets
    'Unit'[Parent_Name] <> "DG" &&
    'Unit'[PERIOD_UNITS] < 25, 1,

 

    'Unit'[Parent_Name] <> "DG" &&
    'Unit'[PERIOD_UNITS] <= 50, 2,

 

    'Unit'[Parent_Name] <> "DG" &&
    'Unit'[PERIOD_UNITS] <= 300, 3,

 

    'Unit'[Parent_Name] <> "DG" &&
    'Unit'[PERIOD_UNITS] <= 1000, 4,

 

    'Unit'[Parent_Name] <> "DG" &&
    'Unit'[PERIOD_UNITS] > 1000, 5,

 

    -- PMI special case
    'Unit'[Parent_Name] = "DG" &&
    'Unit'[PERIOD_UNITS] > 1000, 6,

 

    -- Everything else DG (≤1000) → excluded
    7
)
 
And try again the sorting, if it does not work, please upload the pbix in a cloud service and share here the link so I can inspect it and fix
 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Gopal_PV's avatar
Gopal_PV
Icon for Helper III rankHelper III
1 year ago

Hi FBergamaschi .

Now i am facing cercular depency error. Please find the pbix file in the attachment.

 

 

Thank you