That shows up when the profile is not currently active. For example, if I have a profile that turns off sounds from 10pm-6am it would not be active at 7am. If I look at 11pm I would see that it is active.
If you have a profile based on an action you'll never see it active. For example if you set one to activate when you unlock your phone, it will only be active for that moment when the phone is being unlocked.