Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
emrei
Helper I
Helper I

Filter Using Unrelated Table

‎06-27-2023 01:56 PM

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  the file here

https://drive.google.com/drive/folders/1jgBuVBAcRRBEryNg2XJXlqQ33szhAWEc?usp=sharing

 

emrei_0-1687898939080.png

 

emrei_1-1687898939223.png

 
 

emrei_2-1687875132808.png

Captureaaaa.PNG

Capturebbbb.PNG

Message 1 of 1
256 Views
0
0 REPLIES 0

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All