Forum Discussion

pmdci's avatar
pmdci
Advocate V
10 years ago

gauge dynamic target

Hi,

 

I has a report with a radial gauge and a slicer for the weeks in the year.

 

I have a target of 5000 units per week. So if I select only one week on the slicer, I want to see 5000 as the target. But if I select two weeks, I want to see 10000 units as the target, 3 weeks 15000 units and so on.

 

Is that possible in Power BI?

 

Regards,

P.

Need Help

1 Reply

  • JPC3's avatar
    JPC3
    Advocate I
    10 years ago

    Assuming that you already have a Week column in your dataset then you should simply be able to create a measure like,

     

    • TargetMeasure = DISTINCTCOUNT([WEEKCOLUMN])*5000

    JC