Visual doesn't show Top N date but instead shows all data

[SteveMBSDO]

Hello,

I have 3 graphs which should show the data for the past 28 days. For the lower 2 graphs it works based on a filter. This filter is based on a 'Last N Days' column which shows the difference between the reporting date and the current date, disregarding future dates. Based on this, the bottom 28 values would show me the 28 days in the past from today. That works for the lower 2 graphs.

However, it doesn't work for the upper graph. What happens instead is that it only calculates the values for the 28 days, as filtered, but it also shows the whole year per day with a value of 100% (which it's not by the way). It must only show the past 28 days including current.

Can anyone guide me in the right direction in only showing the past 28 days instead of a full year?

Thank you in advance.

Kind regards,

Steve

[amitchandak]

@SteveMBSDO , Have you used relative date slicer ?

Please share full details