cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
simonliucan Frequent Visitor
Frequent Visitor

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?

 

inner_join.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Exclude values that are blank

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 1
Super User
Super User

Re: Exclude values that are blank

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.    

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 275 members 3,024 guests
Please welcome our newest community members: