Forum Discussion

Vishnu_Prasad's avatar
Vishnu_Prasad
Regular Visitor
5 years ago

Line Graph from 2 related tables

Hi,

I have a table (Table A) with set of stocks which are tracked. Another table(Table B) contains list of competitors mapping of the stocks in Table A. Finally there is Table C with daily stock values of all the shares used in Table A and Table B. 

 

I am trying to develop a line graph synced to a  slicer. My selection of a stock in Table A in the slicer should ideally result in selection of respective competitors in Table B. All competitors and selceted stock values against date are to be shown in line graph.

 

I made a relationship between Table A and Table B to fetch competitor details; Table B and Table C to fetch stock values.  This is resulting in line graph displaying the competitor details correctly on graphs. But I fail to fetch the stock price details of stock selected in Table A. If I connect Table A to table C using the company code, this results ina circular reference.

 

I realise I am missing something very silly in relationship modelling. It would be helpful if anyone could guide a bit on this (I am newbie to PowerBi world).

Thanks in advance.  

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    HiVishnu_Prasad ,

     

    Sample data and expected output would help tremendously.
    Please see this post regarding How to Get Your Question Answered Quickly:
    How-to-Get-Your-Question-Answered-Quickly 
     

    Hope it helps.

     

    Best Regards,
    Caitlyn Yan

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.