I have added to my dashboard a settings menu in which you have different filter options. As example you can filter via a slicer: the month, the year and the company. I need this filter because of other charts within my dashboard. So far so good.
Now comes my problem: The YTD vs PYTD line chart would be filtered by the above three options, which means that the line chart would reflect the relevant month which is chosen only. In this example the filter would be April.
But I want to compare the YTD vs PYTD for the full year on a month to month basis. So I have excluded the YTD vs PYTD line chart visial from the month slicer filter.
The result is of course a full year view.
But as you propably will have notice, the measure for the actual year does not stop by April, but its calculating the whole year which looks strange.
So what I would like to see is a line chart where the YTD line does end with the relevant month slicer setting, but the PYTD line reflects the whole year. Here my example:
I believe I need to adjust my measures, but I can not find a solution online. Can one of you help?
Your reply is much appreciated and I thank you in advanced.
as you will see, the line Act YTD does not stop at the month April, but insready also uses the date which is already in the system for May. FYI, the May data is not yet finalized, i.e. for a reader it is misleading since additional bookings could increase or deacrease the net profit as relfected in the line chart.