Forum Discussion
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 ta...
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