cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdhbr
Regular Visitor

Blank appearing in slicers when relationships (1,N) are created

Dear all,

 

I am quite new to PowerBi and I hope for some guided support! 🙂

 

I have a large dataset which is made of 2 tables:

- one table contains product information

- another table contains demand/supply per calendar week (26 calendar weeks, each product has 26 rows)

 

The problem is, when I create a relationship between the two tables (from the product ID -> 1,N relationship) there are (Blank) appearing in the slicers, which are taking up much of the data... I can't seem to figure out how to get rid of these blanks..

 

Thanks a lot in advance!!

1 ACCEPTED SOLUTION
parry2k
Super User III
Super User III

@jdhbr means you have products in your demand/supply table which doesn't exist in the product table, you can use a visual level filter to say where the product is not blank but you should still fix the underline data.

 

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2
parry2k
Super User III
Super User III

@jdhbr means you have products in your demand/supply table which doesn't exist in the product table, you can use a visual level filter to say where the product is not blank but you should still fix the underline data.

 

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

jdhbr
Regular Visitor

Thanks! Indeed I did not copy the whole table.. (rookie mistake!)

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors