Data isnt filtering after applying filter, when I have show items with no data on

[Krushal]

I have the "show items with no data" on the Core/Reman/New column.

The reason being not all the item numbers have that field, and I need to be able to view that item no when i use the slicer "item no"

When I use the slicer to filter data using "core/reman/new" slicer , it still shows me the blank rows.

In short,  how do I not hide blank data while using a slicer "only" ?

In this case, I want to see only rows that have CORE in the "CORE/REMAN/NEW" field only when I use the slicer.

If I am not using the slicer, I want to see all the data in the table.

Can someone help ?

[v-chuncz-msft]

@Krushal 

You may try setting cross filter direction to 'Both' in the Edit relationship dialog.

[Krushal · Accepted solution]

@v-chuncz-msft  Changed the relationship from Many to One , single direction did the trick. As "Final Part no"(469) is a subset of "Item no"(1700) and the CORE/REMAN/NEW attribute was being drawn from Re-id Percentage file.

[amitchandak]

When you are filtering CORE, is it showing CORE and BLANK or others are also shown ?

[Krushal]

@amitchandak  it only shows CORE and BLANK

[amitchandak]

If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Krushal]

Spoiler

@amitchandak I dont think I can share the Pbix file but is it possible for me to share my screen with you on skype or webex or teamcentre ?