Conditional Formatting on Advance Card Visual

Good morning v-juanli-msft ,

Yes, exactly what I am after! When I change the date filter by month, a new goal would be measured up against an existing value. I know that in theory, I could go and adjust it at the start of the month for that new month, but then if I were to compare how we did to our goal in January, the conditional formatting would be set for February's goal and the color change would be incorrect. If I were to compare how we did to our goal last October, the conditional formatting would be set for February's goal and the color change would be incorrect. So yes, as you mention, the value to be dynamic based on the selected month.

Do you have a solution to my problem? Thank you so much for the reply, it made me happy to see your reply in my Inbox. 

- mrolim