Hello Power BI-ers!
So I was wondering if anyone knew how to program the conditional formatting feature for Advance Card that would change based on a Goal.
As the visual currently stands, (from what I know), the formatting you can do is off a fixed number. Reference to the picture below:
Now, this would work great if my goal was fixed. I could set in my two conditions and we're good to go. However, my goal changes from month to month. Ideally, I'd like it set up where the color formatting would change based on the goal number on a monthly basis. As of right now, the colors are inside of a larger circle (shown below) that changes based on the filtered date. So for example, this picture below is Safety. If the number of incidents during a certain date range is 0, then the circle is Green. If the number of incidents during a certain date range is more than 0, so 1, then the circle is Red. I'd like for the circle to change colors based on a ever changing goal number that is inputted into a column that I've linked to the dashboard.
Any insights here? Thank you so much!
Do you want the "Value" to be dynamic according to the selected month?
For example, for January, if "incidents" >0, then red, else green,
for February, if "incidents" >3, then red, else green,
Is my understanding right?
You could refer to this bolg how to use Advanced 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.