Forum Discussion

simonliucan's avatar
simonliucan
Frequent Visitor
7 years ago
Solved

Exclude values that are blank

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?

 

Need Help
  • AlB's avatar
    AlB
    7 years ago

    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.    

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    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.