Exclude values that are blank

[simonliucan]

Hi,

I am new to Power BI. I have a chart below, Actual and Plan numbers are from different fact tables (Actual fact and Plan fact). Both fact tables are joinning to same time dimension table. I don't want to show DEC 2019/JAN 2019/FEB 2019 where Actuals are blank, how can I do that?

[AlB · Accepted solution]

Hi @simonliucan

I think if you place your '... Actuals...' measure in the Visual level filters and choose 'Show items when the value' is not blank, you will have what you want.