Forum Discussion

AlmantasPBIguy's avatar
AlmantasPBIguy
Frequent Visitor
2 years ago

Different sort order per category

Hey guys,    Lets say I have a table with 3 columns: Attribute, Category and Order and the order is different per category. I want to sort the attributes by the order, depending on what category is...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AlmantasPBIguy ,

 

Here I will give you two workarounds.

1. Your issue should be caused by that you want to sort the same value in [Attribute] with different orders. Power BI doesn't support us to do this. We need to sort the unique key word with the order column. I suggest you to combine [Attribute] and [Category] column as a unique key column.

Combine = COMBINEVALUES("-",'Table'[Attribute],'Table'[Category])

2. You can turn off "Text wrap" in column headers and reduce the width of [Order] column in your visual.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.