gauge dynamic target

[pmdci]

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.

[JPC3]

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