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><img /></P><P>&nbsp;</P><P><img /></P><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV><P><img /></P><P><img /></P><P><img /></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><img /></P><P>&nbsp;</P><P><img /></P><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV><P><img /></P><P><img /></P><P><img /></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