Forum Discussion
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%
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.
5 Replies
- SamanthaPuaXY
Helper II
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. 
rohit1991Super User
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.
v-pnaroju-msftCommunity Support
Thank you, SamanthaPuaXY, rohit1991, for your response.
Hi Rohiniv25,
We would like to check if the solution provided by SamanthaPuaXY , rohit1991 has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.
If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.
Thank you.
- v-pnaroju-msft
Hi Rohiniv25,
We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.
If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.
Thank you. - v-pnaroju-msft
Hi Rohiniv25,
We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.
Thank you.
