March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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 ?
Solved! Go to 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.
You may try setting cross filter direction to 'Both' in the Edit relationship dialog.
@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.
When you are filtering CORE, is it showing CORE and BLANK or others are also shown ?
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...
@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 ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |