The following calculated field should do the trick. I've attached a workbook as well, but it is unfortunately 10.2. Hopefully the screenshot provides enough information.
Trialing 3 Months.twbx 39.3 KB
Thank you so much for your help , I got the bars highlighted and working using your workbook.
Glad to help! If you wouldn't mind, could you please mark the answer as correct so this doesn't show up as unanswered anymore? Thanks