Forum Discussion

Uxia's avatar
Uxia
New Member
8 years ago
Solved

2 Tables - Show blank rows

Hello,

 

I am working in Power BI Desktop with Salesforce Objects, I have to combine 2 tables (relationship Many:1) 

 

  • Table 1 (Opportunities): contains all opportunities
  • Table 2 (Plan) : contains the opportunities that have a plan and all the data fields in the plan section.

What I am trying to show in my dashboard table are some fields of the Plan table for opportunities that have a plan and blanks in case the opportunities that don't have a plan.

 

Due to in the Plan table the opportunities with no plan do not exist, every time I include any field of the Plan Table in the dashboard automatically removes the opportuties with no plan.

 

I have tried to create a new column in Table 1, with the data of table 2 where the relationship field matched with function Related but it does not allowe me to create this relationship.

 

Could anyone please point me in the right direction with this?

 

Many Thanks,

 

Uxia

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Uxia,


    I test with your sample and I found if I create relationship, these blank score and rating records will auto hide. I try to use 'show items with no data' option but not work.


    For your scenario, I'd like to suggest you break relationship and create calculate column or measure with lookupvalue function to find out related score and rating.

     

    Reference link:

    Favorite Quick & Easy DAX: Lookup Values

     

    Regards,
    Xiaoxin Sheng

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Uxia,


    Can you please share some sample data and expected result? It will be help for  clarify your scenario.

     

    Regards,

    Xiaoxin Sheng

    • Uxia's avatar
      Uxia
      New Member
      8 years ago

      Hi Anonymous,

       

      Thanks for the reply, I cannot share the actual data as it is confidential but I made a simple example that illustrates the situation

      • This would be Table 1 with all the opportunitities:

       

       

       

      • This would be Table 2 with the Plan and the data

         

      • This is what I want to achieve:

      •   This is actually what I get:

       

       

      As you can see, only the Opportunities that exist in Table 2 are the ones shown in the final table, but I want all the opportunities in Table 1, and if these do not exist in Table 2 then blanks should appear in the missing rows.

       

      Hope this clarifies.

       

      Let me know if you need anything else.

       

      Thanks again,

       

      Uxia

       

       

       

      • Uxia's avatar
        Uxia
        New Member
        8 years ago

        Hi Anonymous

         

        Here the missing table 2:

         

        Thanks,

         

        Uxia