DAX: Filter one of two fields on same visual

[SALutions]

We are atempting to show two values on a time graph by month. One value to show actual revenue for past months and the other value to show estimated revenue for future months. The issue is; when the current month is not over yet, it shows the actual value in that month which we do not want, but only estimated revenue for current and future months. (Can't show actual revenue until month is closed)  We cannot filter out actual revune because it reacts with the estimated value as well and are left with nothing, estimated or actual, after that filter date. How could we solve? 

Need to show black until end of March and blue after March.

Black = Actual Revenue 

Blue = Estimated Revenue

[v-sihou-msft]

Hi @SALutions,

According to your description, you don't want to show actual values until current month has passed. Right?

In this scenario, you can add a calculated column to replace all Revenue in current month into '0'. Please refer to expression below:

=IF(table[month]=month(today()),0,table[Revenue])

Then you can include this calculated column into your chart.

Regards,

[SALutions]

Thank you for your reply! You are correct, I do need to filter out current month's actual revenue. Your solution seems viable but to avoid some overhead with calculated columns, we would like to try and solve with an Actual Revenue measure by filtering the dates somehow instead. Any ideas?