Forum Discussion
Mapping Data Tables
Anonymous is the product category that contains a unique value in table 2? if yes, then you can set a relationship on category between table 1 and table 2, which will be one to many relationship, one on table 2 side.
In visual, use category and target from table 2 and the rest of the columns from table 1 and that will do it.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi parry2k ,
Yes the Table 2 has unique values of product Category.This is only working for the bar graph by product category.
I also have graphs by Reason Code, Reason Category and Posting Period. How to make Table 2 to talk to the Reason Code, Reason Category and the Posting Period Columns so that the TARGET is reflected in the other graphs as well.