Forum Discussion

alisaleh's avatar
alisaleh
Icon for Advocate I rankAdvocate I
4 years ago

Adding Blank Option to Slicer

Hi ,

 

I have a scenario where there is a relationship where the cardinality is (0:1->* ) so in the many side of the relationship there could value or no value (null) back. Let say theoratically we have a category table and an Item table where the Item can be assigned a category or not. The problem is if I create 
Many:1  relationship between from categoy to Item then I add category slicer, the slicer will show all category values but that means if I select all only the items that are associated with selected categories will be visible in the items table which makes sense but there is no option for (blank). the question is how to add that to the slicer so that I can show items with null\blank category? Thanks

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    alisaleh if I were you, instead of blank/null, which doesn't look good, replace the null/blank category with "Unknown" in Power Query and add thus "Unknown" in the category table and then it will be user-friendly and will make things more robust. Let's clean the data before start developing the reports.

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

  • alisaleh's avatar
    alisaleh
    Icon for Advocate I rankAdvocate I
    4 years ago

    Thanks parry2k  for your response.

    I wish if its that simple. The Category table and Item table are filtered by project first which means I have to add Uknown record to every project which can be cumbersome.