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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.