Forum Discussion

JesterGrafix's avatar
JesterGrafix
Regular Visitor
3 years ago

Data disapearing

I have table that I am trying to create in Power Bi. This table is pulling from multiple data sets. The first data set has all the material numbers that I need. The second data set has Puschasing Document Numbers. When I add the Puschasing Document Numbers field to the table, all of the material numbers that do not have an associated Puschasing Document Number gets removed from my list. I need these to stay so that I can see whcich ones do not have a Puschasing Document Number. Is there any way that I can make this work?

Need Help

2 Replies

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

    Create another matrix, right click on the material numbers and tick "Show all with no data". Then go into the visual filters and use the advanced filter to show those where Purchasing Doccument Number is blank. 

  • hummingbird's avatar
    hummingbird
    Helper II
    3 years ago

    Hi,

    Yes, there is a way to make this work in Power BI. You can use the "Left Join" option in Power BI to combine the two data sets, keeping all of the records from the first data set (Material Numbers) and only those records from the second data set (Purchasing Document Numbers) that have a matching Material Number. This will result in a table that includes all of the Material Numbers, including those that don't have a corresponding Purchasing Document Number. You can also add a calculated column to your table to indicate which Material Numbers have a corresponding Purchasing Document Number and which ones do not.

    Hope this helps.