Forum Discussion

Rohiniv25's avatar
Rohiniv25
New Member
1 year ago
Solved

rearranging the order

  all these are under sla wanted to rearrage this like sla in the first then the percentage not able to move as this is filtered from the SLA   this should be invoiceerror dls sla%  
  • rohit1991's avatar
    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.