https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filter-Using-Unrelated-Table/m-p/3305126#M7720 <P>Hi everyone. I have the following two graph visuals made with calculated columns in the Date Table which I attached pics of its content. I want them to be dynamic using the two filters on the left which comes from the Project Type table. The issue I am having is that I have two column (actual completion date and target completion date) that I need to relate from Project Dates to Date. I tried using the userelationship function but since my calculated columns use filter in gives an circular dependency error. I have attached&nbsp; the file here</P><P><A href="https://drive.google.com/drive/folders/1jgBuVBAcRRBEryNg2XJXlqQ33szhAWEc?usp=sharing" target="_blank" rel="noopener nofollow noreferrer">https://drive.google.com/drive/folders/1jgBuVBAcRRBEryNg2XJXlqQ33szhAWEc?usp=sharing</A></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="emrei_0-1687898939080.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934314iAE6DDEA2C982C259/image-size/medium?v=v2&amp;px=400" role="button" title="emrei_0-1687898939080.png" alt="emrei_0-1687898939080.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="emrei_1-1687898939223.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934315i172C3D29D19A7A51/image-size/medium?v=v2&amp;px=400" role="button" title="emrei_1-1687898939223.png" alt="emrei_1-1687898939223.png" /></span></P><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="emrei_2-1687875132808.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934106i88716576991AA263/image-size/medium?v=v2&amp;px=400" role="button" title="emrei_2-1687875132808.png" alt="emrei_2-1687875132808.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captureaaaa.PNG" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934323iC07FC810FCCFC648/image-size/medium?v=v2&amp;px=400" role="button" title="Captureaaaa.PNG" alt="Captureaaaa.PNG" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capturebbbb.PNG" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934325iE918B37EBCAFEDB0/image-size/medium?v=v2&amp;px=400" role="button" title="Capturebbbb.PNG" alt="Capturebbbb.PNG" /></span></P> Tue, 27 Jun 2023 20:56:27 GMT emrei 2023-06-27T20:56:27Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filter-Using-Unrelated-Table/m-p/3305126#M7720 <P>Hi everyone. I have the following two graph visuals made with calculated columns in the Date Table which I attached pics of its content. I want them to be dynamic using the two filters on the left which comes from the Project Type table. The issue I am having is that I have two column (actual completion date and target completion date) that I need to relate from Project Dates to Date. I tried using the userelationship function but since my calculated columns use filter in gives an circular dependency error. I have attached&nbsp; the file here</P><P><A href="https://drive.google.com/drive/folders/1jgBuVBAcRRBEryNg2XJXlqQ33szhAWEc?usp=sharing" target="_blank" rel="noopener nofollow noreferrer">https://drive.google.com/drive/folders/1jgBuVBAcRRBEryNg2XJXlqQ33szhAWEc?usp=sharing</A></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="emrei_0-1687898939080.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934314iAE6DDEA2C982C259/image-size/medium?v=v2&amp;px=400" role="button" title="emrei_0-1687898939080.png" alt="emrei_0-1687898939080.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="emrei_1-1687898939223.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934315i172C3D29D19A7A51/image-size/medium?v=v2&amp;px=400" role="button" title="emrei_1-1687898939223.png" alt="emrei_1-1687898939223.png" /></span></P><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="emrei_2-1687875132808.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934106i88716576991AA263/image-size/medium?v=v2&amp;px=400" role="button" title="emrei_2-1687875132808.png" alt="emrei_2-1687875132808.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captureaaaa.PNG" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934323iC07FC810FCCFC648/image-size/medium?v=v2&amp;px=400" role="button" title="Captureaaaa.PNG" alt="Captureaaaa.PNG" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capturebbbb.PNG" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/934325iE918B37EBCAFEDB0/image-size/medium?v=v2&amp;px=400" role="button" title="Capturebbbb.PNG" alt="Capturebbbb.PNG" /></span></P> Tue, 27 Jun 2023 20:56:27 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filter-Using-Unrelated-Table/m-p/3305126#M7720 emrei 2023-06-27T20:56:27Z