https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationships-between-columns-and-rows/m-p/692754#M2164 <P>Hi. My problem is that I'd like to to connect two tables and I just don't know to do it. In the other table the distance is it's own column and in the other table the distances (10, 20, 30 etc) are the columns. I have to use distances as columns, because I wan't to draw a line from the points that specific distance has. I want to create a connection between these two, because I want to highlight some details from a chart made from 2. table when a value is chosen from the 1. table. Do you have any ideas how I should do this? Thanks in advance:)<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1 Table." style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/164873iF76C7C51FBC40AF2/image-size/large?v=v2&amp;px=999" role="button" title="photo1.PNG" alt="1 Table." /><span class="lia-inline-image-caption" onclick="event.preventDefault();">1 Table.</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2. Table" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/164874iFC35A208C9299B13/image-size/large?v=v2&amp;px=999" role="button" title="Capture2.PNG" alt="2. Table" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">2. Table</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Chart from 1 table ( creates surface from points)" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/164875i67E7A6FADFE87293/image-size/large?v=v2&amp;px=999" role="button" title="Capture3.PNG" alt="Chart from 1 table ( creates surface from points)" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Chart from 1 table ( creates surface from points)</span></span></P> Thu, 16 May 2019 12:39:14 GMT Anonymous 2019-05-16T12:39:14Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationships-between-columns-and-rows/m-p/692754#M2164 <P>Hi. My problem is that I'd like to to connect two tables and I just don't know to do it. In the other table the distance is it's own column and in the other table the distances (10, 20, 30 etc) are the columns. I have to use distances as columns, because I wan't to draw a line from the points that specific distance has. I want to create a connection between these two, because I want to highlight some details from a chart made from 2. table when a value is chosen from the 1. table. Do you have any ideas how I should do this? Thanks in advance:)<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1 Table." style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/164873iF76C7C51FBC40AF2/image-size/large?v=v2&amp;px=999" role="button" title="photo1.PNG" alt="1 Table." /><span class="lia-inline-image-caption" onclick="event.preventDefault();">1 Table.</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2. Table" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/164874iFC35A208C9299B13/image-size/large?v=v2&amp;px=999" role="button" title="Capture2.PNG" alt="2. Table" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">2. Table</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Chart from 1 table ( creates surface from points)" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/164875i67E7A6FADFE87293/image-size/large?v=v2&amp;px=999" role="button" title="Capture3.PNG" alt="Chart from 1 table ( creates surface from points)" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Chart from 1 table ( creates surface from points)</span></span></P> Thu, 16 May 2019 12:39:14 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationships-between-columns-and-rows/m-p/692754#M2164 Anonymous 2019-05-16T12:39:14Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationships-between-columns-and-rows/m-p/693785#M2172 <P>Hi,</P><P>&nbsp;</P><P>I am not sure that I understood what exactly you want to do but you can use <A href="https://docs.microsoft.com/en-US/power-bi/guided-learning/introductiontodax" target="_self">DAX</A> to adjust your data.</P><P>&nbsp;</P><P>Kind Regards,</P><P>&nbsp;</P><P>Evgenii Elkin,<BR />Software Engineer<BR />Microsoft Power BI Custom Visuals<BR />pbicvsupport@microsoft.com</P> Fri, 17 May 2019 13:21:30 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationships-between-columns-and-rows/m-p/693785#M2172 v-evelk 2019-05-17T13:21:30Z