Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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 ?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |