Is there a way to limit one of the series in a combo chart?

[mihira]

Is there a way to limit one of the series in a combo chart? Say I want to see one of the series show up till current month and the other till end of the year. I usually do this is SSRS using expressions, is there a way to achieve this is PowerBI?

[andre · Accepted solution]

if you have a measure for Actual and another for Forecast and you are trying to have a chart that displays Actual for historic values and Forecast for future months, you can create a calculation that combines the two by checking the date value or Actual value and if Actual is null or month is greater than current month, then show Forecast

[Arieln]

I cant think of a way of doing it by simply configuring the visual. I am imagine you can define a calculated measure that will "zero out" values you dont want but I not sure  ....

Do you have a picture of what you are trying to build? Others here might have better ideas