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 d...
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.    

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity 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.