Forum Discussion
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
- AnonymousNot 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-QuicklyHope it helps.
Best Regards,
Caitlyn YanIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.