Forum Discussion
Issue with year to date comparisons
Hi Zoe,
Thanks for your reply, but it is nog exactly what I want. But I understand that because my question wasn't clear and I didn't add an example. But anyway thanks for your reply. First of all I can't find how to upload a file like you did. Because I changed your example a little bit so it shows my problem.
But I can add a picture of the view. I want to seed month values in de chart of this year (amount), last year (meting) and budget (budget). So I can compare the results with both previous year and the budget. The three tiles under the chart I want to show YTD values for all three of these measures. But the problem is they count the whole year instead of only YTD. For example the actuals of 2019 should be 21 instead of 22 because the last one is in december so not a YTD value. The meting voor previous year should be 23 instead of 26 (3 for dec 2018). And the budget should be 24 instead of 24 (4 in dec).
However when I click in the chart on a month, let's say march, then I want the tiles to show 2, 6 and 4 (resp; this year, previous year and budget).
I hope I explained the issue more clear. In this example I used the card cart voor the tiles (because you did so in your example) but in my real dashboard I was using the KPI visual. Not shure which one is right.
Thank you so much!
Hi MvdBlom,
You could try to upload your sample on OneDrive or other place I could access it, then I will help you more correctly. By the way, you could try to use simple data sample to repalce your real data, and inform me your expected output.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- MvdBlom6 years agoNew Member