Forum Discussion

Brijesh's avatar
Brijesh
Frequent Visitor
6 years ago

Getting values from another related table

Hi,

I'm fairly new to the Power BI.

Table A (1 side in the relationship) - Has only current milestone

Table B (many side in the relationship) - Has all the milestone (completed as well as upcoming)

 

Trying to design a visual (data from Table A) with report tooltip (data from Table B). Where I want to diplay all the related milesotnes with relevant information from Table B (many side table in the relationship)!

 

Currently I'm getting only one record (related to the current milestone). However, I want tooltip to display all the milestones!

 

Is this something possible? If so, how can we do that?

 

Thanks,

Brijesh

 

A visual has data from 

Need Help

3 Replies

    • Brijesh's avatar
      Brijesh
      Frequent Visitor
      6 years ago

      amitchandak ,

      I'm using a report tooltip. On my report tooltip, data coming from my Table B (the many side) Whereas, on my visual, data coming from my Table A (one side). I have a case status (milestone) table (Table A) which has current status (milestone) of a case. The other table, Table B has all the status (milestone) listed with its target date etc. which I want to pull out all of them to show up on tooltip. Hence, I'm using a report tooltip, but it is showing up current milestone data only and not the other milestones!

      Note: Each case could have a minimum 4-5 milestones, based on type of case. 

       

      Example;

      Table A

      Case#    Milestone    Owner

      1234      abc              User1

      5678      abc              User2

       

      Table B

      Case#    Milestone    Start Date     Target Date    Completion Date

      1234      xyz              01/07/2020  20/07/2020     14/07/2020

      1234      abc             01/07/2020  30/07/2020     

      1234      def             01/07/2020  10/08/2020     

      1234      ghi             01/07/2020  15/08/2020   

       

      Currently, when I hover over case # in Table A, it is showing me only one milestone from Table B as highlighted in above example. Ideally, I would like to display all four milestones from Table B with its relevant information!

       

      I hope it makes sense now.

       

      Appreciate your help.

      Brijesh

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI Brijesh,

        You can create a calculated table with table b records and link table a with case id.
        Then you can create a report tooltip page with records from this table and add measures to display the date that you wanted on specific records.

        Regards,

        Xiaoxin Sheng