Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a modeling inquiry (or command question) in a 3 tables model.
T_Information has the column "PlanCode." The table filters the 2nd table T_Defective to get the list of defects in a model for a certain day.
T_Defective has the column SEQ (process sequence number ID) to get the origin of the defect.
And there's this 3rd table M_Process with the columns of process names, the SEQ number and the model's name code MCode.
After filtering I can get the following visualization from the 2nd table.
Now, if I change the X-axel to show me the process names from the 3rd table, the graph retrieves all process names of the model and counts all defects (see graph below).
How can I get the visualization right? To get number of defects by process name?
Thx in advance.
Hi @EleJim In order to avoid many to many issues, you could try and create a surrogate key as explained in the below link and see if that suits the need
Can't create a relationship? Time for a surrogate key in Power BI! (youtube.com)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
37 | |
31 | |
26 |
User | Count |
---|---|
95 | |
50 | |
43 | |
40 | |
35 |