79727682

Date: 2025-08-06 18:03:36
Score: 1
Natty:
Report link

If you were able to give each combination an item ID (outside of PBI desktop), and then use the sort column based on that specific ID, this would work.

For example,

ID Item - Classification Sizing - Classification Desired Order
BDK Bed King 1
BDQ Bed Queen 2
BSK Box Spring King 3
BSQ Box Spring Queen 4

You would then create the order column based on ID and "Sort by Column" with this the order.

If you only sorted on the "sizing" classification, all Kings will be grouped together, all Queens will be grouped together, etc. (which I'm sure you've already seen).

Another way to accomplish this (depending how you want to do it) would be a custom column using DAX that would look something like this:
(For just itemorder)
OrderColumn = IF(table[Item] = "Bed", 1
IF(table[Item] = "Box Spring", 2
...................)

OR

(For item AND size order)
OrderColumn = IF(AND(table[Item] = "Bed", table[Sizing] = "King"), 1
IF(AND(table[Item] = "Bed", table[Sizing] = "Queen"), 2
...................)

Reasons:
  • Long answer (-1):
  • No code block (0.5):
  • Filler text (0.5): ...................
  • Filler text (0): ...................
  • Low reputation (1):
Posted by: GetSmithed