Using KPI with a set number

[Anonymous]

Hi,

I'm trying to build a report that our company will be looking at weekly.  We have various goals we try to reach each week, and I'm trying to figure out the best way to integrate this into a report.

For example one of our "KPI"s we look at is count of leads created in a week.  I have this displaying in a Card.

Let's say my goal is 15. If the # leads created is >= 15 in the week, I want it to show green else if < 15 I want it to show red.  Not exactly sure if I should be using the KPI visualization or a formatting some how?  I will be adding more tables / goals / visualizations to this report!

Any insight or advice would be great!

Thanks,

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can create a new measure to set your goal.

goal =
15

Suppose week1 has 16 IDs, and week2 has 9 IDs. Create a calculated column and use these fields to get a KPI visual.

CountIds =
CALCULATE ( COUNT ( Sheet2[id] ), ALLEXCEPT ( Sheet2, Sheet2[week] ) )

You can set the color in the “Color Coding”

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.