Column Data Color Formatting not working Power BI

Hi deonaman ,

Thank you for your interest in this case. The method provided is basically correct, I just performed a test and a more detailed description.

I ran the test, this is my example data, %Actual is a measure.

Be sure to set the data type (Actual %) of the measure to a percentage. Sometimes the base format may still be a number even though the data is displayed as a percentage.

Under the Format pane, select “column”>>f(x) to set the conditional format. When setting the condition format, use the “Number” format instead of the “Percent” format after checking your measure.

This is the original visual object:

This is the visual object after applying conditional formatting:

If it hasn't been resolved, please provide a Power BI Desktop file in progress (with sensitive information removed) that fully covers your issue or question in a usable format (not a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive (set up public access), SharePoint, or a Github repository, and then share the URL of the file.

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!