Forum Discussion

TylerMunro's avatar
TylerMunro
Regular Visitor
8 years ago
Solved

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 ins...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

TylerMunro's avatar
TylerMunro
Regular Visitor
8 years ago

Thanks Angelia,

 

It worked a treat :)