Welcome to the Forum.
I apologize at the outset if I did not fully grasp the issues at hand.
If the attached do not adequately match your setup,
please modify them to make them closer.
I made a very simplified dataset, and probably an overly complicated
chain of calculations to arrive at the goal of just showing the selected quarter,
coloring it by ratio, and sorting it by last quarter regardless of a second filter.
I think the key point may be the use of a Level of Detail calculation
to just get the value of the quarter in question, while leaving all
the other quarter data intact.