This is because you can’t sort a visualization by a field that isn’t in the visualization in Power BI. SEE: Here’s everything you need to know about Microsoft Power BI.