Line and clustered colum chart - start line at custom point on X-axis?

[Anonymous]

Hi!

I have a visualisation with has as column the monthly value of leavers rate for that month, then on the line I have the Rolling-12 for the same rate. My problem is that I dont have a full R12-value until January 2020, I would like the visualisation to show 12 month of monthly values but the R12-line to start at january 2020. 

I have thought and tried to change my measure, but the measure should have all the data, it is just the visualisation that should now show it. There is no way to filter just the line that I have found, then I filter the entire visualisation, which I dont want to. 

I can of course revert to having to different visualisations, one for 2019 without the line and one for 2020 with it but it will be visible and less dynamic. 

I was hoping for a smart solution to this problem 🙂 

Help? 

[Greg_Deckler · Accepted solution]

While not the recommended route, creating measures for specific visualizations, I would create another measure like:

Measure =
VAR __Date = MAX('Calendar'[Date])
VAR __Value = [Your Original Measure]
RETURN
IF(__Date < DATE(2020,1,1),BLANK(),__Value)

[Anonymous]

That worked perfectly! THANK YOU!!!!

[Greg_Deckler]

Great! 🙂