Variance column not sorting correctly

Hello @Stuart,

What you can do is create separate measure for the % figures and the normal or actual figures. And for the % figures then you can apply the % format from “Measure Tools” section by selecting the % symbol.

Also I’m providing 2 links where similar sort of query was asked onto the Forum earlier regarding the % format.

Hoping you find this useful.

Thanks & Warm Regards,
Harsh