troubleshooting Question

Creating relationships between tables with no common columns in Power BI

Avatar of Juan Ocasio
Juan OcasioFlag for United States of America asked on
Power BI* DAX
9 Comments1 Solution15 ViewsLast Modified:
Hello Experts:

I have several tables that I want to create a visual for.  Two of the tables are below:





What I am trying to do is create a relationship so that I can associate the sales to the target.  I am also trying to create a visual that will display this relationship, possibly in a progress bar type display where the target like the following (given Sales for Year 2021 and Period 1). For the below example, the sales were greater than the target, so the progress is green. There is also a situation where it would be yellow if it's a % (say 90%) to target, and red if it's 75% or lower to target.  These values also come out of the Targets table, so if you can help with that, great:


Any given year, I may have a bunch of different Metrics and targets, but I'm just focusing on trying to get this to work.  Also, I am not married to the above visual, so if there is a better approach to show several metrics based on the year and period, please let me know  I did try to look this up online, but fell short.  I found one site that seems like it explained it, but didn't really provide a step by step and I quickly got lost.

Many thanks for any help you all can provide!
ASKER CERTIFIED SOLUTION
Juan Ocasio
Continuous Process Improvement Lead

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros