Forum Discussion
KPI's & Power BI
Hi All,
I have been tasked with setting up a KPI dashboard for my team in Pwer BI, I am failry tech savvy but not at a developer level.
My query is can a target in a gauge be dynamic? For instance please see table below; The KPI for Joe is to complete three jobs a day. I have manually set that target in the gauge no problem. When i insert a slicer and select multiple dates it shows the count of Job Complete across those dates.
What i would like to know if it is possible to change the target in the gauge by the dates selected so the target is multiplied by how many days.
For instance on the 8/2 the target would be 3 and the jobs completed would be 4 showing he has met the kpi. Or if i select the 8/2, 7/2, 6/2 the count of jobs complete is 9 but the target remains at 3. I need that target to be 9 (multiplied by count of dates).
Please refer to table below.
Any help would be greatly appreciated!
Tyler
Resource Job Type Complete Date
| Joe | Metal | Yes | 8/02/2018 |
| Joe | Metal | Yes | 8/02/2018 |
| Joe | Wood | Yes | 8/02/2018 |
| Joe | Wood | Yes | 8/02/2018 |
| Joe | Metal | Yes | 7/02/2017 |
| Joe | Wood | Yes | 7/02/2017 |
| Joe | Wood | No | 7/02/2017 |
| Joe | Metal | Yes | 6/02/2017 |
| Joe | Metal | Yes | 6/02/2017 |
| Joe | Metal | Yes | 6/02/2017 |
Hi TylerMunro,
Create a measure using the formula below, and select it as target level.Target = CALCULATE(DISTINCTCOUNT(Table2[Date]),ALLSELECTED(Table2))*3
select 2018/8/2 select 8/2, 7/2, 6/2 in slicer
Best Regards,
Angelia
2 Replies
v-huizhn-msftMicrosoft Employee
Hi TylerMunro,
Create a measure using the formula below, and select it as target level.Target = CALCULATE(DISTINCTCOUNT(Table2[Date]),ALLSELECTED(Table2))*3
select 2018/8/2 select 8/2, 7/2, 6/2 in slicer
Best Regards,
AngeliaThanks Angelia,
It worked a treat :)
