Hi Ana, without a sample workbook it is difficult to tell what the exact answer to your question would be.
Have you tried: Customizing Key Progress Indicators | Tableau Software
For more complex views you can build this:
If the above suggestion does not work for your needs, a sample workbook along with the desired result will help the community better understand your question.
Yes, I have looked at that forum. Not exactly what I am looking for. I cannot share the workbook, it has sensitive information. However, here is the a snapshot of it as well as what I am looking for. I am able to do it by creating a separate sheet in excel that shows the Actual vs the Benchmark and creating it in the view. The problem is, that when you filter in Tableau by month the KPI is not correct. So I want to know if there is a way to just do it in tableau without using excel.
There are different ways of doing this (Such as using LoDs to calculate the needed measures so that they are not affected by filtering), but without really seeing/understanding your data, all we can really do is guess.
For sensitive data, please refer here