Forum Discussion
rearranging the order
- 1 year ago
Hi Rohiniv25 ,
In Power BI, if you're working with a visual filtered by the SLA field and trying to rearrange the order of the displayed items, it can be tricky since visuals respect the sorting and filtering logic tied to the field. In your case, you want to bring "Invoice Error Rate" first, followed by "Percentage of Justified Complaints v Hire Provided" (DLS), and then the SLA percentage metrics like "SLA % <30s" and "SLA % Abnd <30s."
To achieve this custom order, you can create a new column in your data model (either in Power Query or using DAX) that assigns a sort order number to each SLA item based on how you want them displayed. For example, assign 1 to "Invoice Error Rate", 2 to "DLS", 3 to "SLA % <30s", and so on. Then, in your visual, use that new column to sort the SLA field. This method allows you to override the default alphabetical or numeric sort and gives you full control over the display order in your visual even when filters are applied.
Hi Rohiniv25 , you can consider ranking the categories under SLA column and sort accordingly.
If not you can just sort down the SLA column if you just want SLA at the top and the rest does not matter.