Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Krushal
Helper I
Helper I

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

2020-01-20_15-45-39.jpgI 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 ?

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

 

 
 
 

Printer Mac.PNG

View solution in original post

6 REPLIES 6
v-chuncz-msft
Community Support
Community Support

@Krushal 

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

 
 
 

Printer Mac.PNG

amitchandak
Super User
Super User

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

@amitchandak  it only shows CORE and BLANK

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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 ?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.