Forum Discussion
Calculated measure based on date hierarchy
Hi v-ljerr-msft
Here's a screenshot that will probably help us conclude this thread (-;
As you can see, the "Monthly Trend" measure returns the correct result ((28-27)/27)=4%
However, when using the conditional "Trend" measure as a line, it does some calculations on every month, like a moving average or something like that.
Is it possible to make the measure result (In this case 4%) displayed like a dotted average line with the same value along the whole chart? (As if Y=0.04 all the way?)
Thanks!
Hi Anonymous,
Is it possible to make the measure result (In this case 4%) displayed like a dotted average line with the same value along the whole chart? (As if Y=0.04 all the way?)
I think this could be done. Could you share a sample pbix file which can reproduce the issue? So that I can further assist on this issue. You can upload it to OneDrive or Dropbox and post the link here, or sent it to me in private message. Do mask sensitive data before uploading. :smileyhappy:
Regards