Open this post to understand what’s happening. This is normal with a Role column.
Are you using Roles for Row Ownership to secure your data, or are you simply using it to control visibility and filters. If data security is not your goal, you might be better off not using the User Profile Role functionality and instead use a normal column as a Pseudo Role that’s not configured as a User Profile Role. You can still use it to control visibility and filters.
The main purpose of Role functionality is for data security through a Row Ownership.