Forum Discussion
Calculated measure based on date hierarchy
Yes, modifying the axis does help, but going back to what I wanted to achieve,
I now have 3 good Trend results for days, weeks and Months. Each trend resultvus a single number representing the difference in percents between the average of 1st day/week/month to last day/week/month
Placing a single result on a chart does not make sense, for example, if I calculate
The difference between average of July May, the result on the graph will look like a moving average, right?
If I want to stick to a kpi/trend, is ihere trend formula that I can add, that
Will look like a real trend line?
Using my phone for this post. If scteenshots are required I will add some early next week.
Thanks a lot. And keep this smilies coming ☺👍
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!
v-ljerr-msftMicrosoft Employee
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