Forum Discussion
jracer007
Helper IV
Helper IVGauge with dynamic target
Hello community, Today I wanted to request your help to build a gauge with the following characteristics: -The target value 'MITIGOAPP v1' must be equal to the one in the current month. Example: in...
jracer007Helper IV
Helper IV
parry2k
Super User
Super Userjracer007 is this how your data is? If that is the case then on yoru gauge visual just put "Target" column in Target value and actual in value
- parry2k
ok, gotcha, so here is what you need to do, convert your month to date field and then you can use relative filtering on this date field to always give you current month, give me few minutes and i will send you pbix file. i'm going to convert you month to english month so it is easy to work for me.
- jracer007
but how do you take the current month?
- parry2k
aha, got it. so when you say current month, you mean current calendar month, presently Dec, 2017
- jracer007
exactly
- jracer007
A thousand thanks parry2k was just what I need
- jracer007
Hello,
One more thing, how do I visualize the percentage that is needed to reach the goal?