Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Experts,
I have two table: first table is used for sorting and second table for calulating Cpk.
Table 1:
Table 2:
Realtionship error:
I am mapping Ylabel column from table 1 as Y column and X.1 coulmn from Table 2 as X column in matrix.
As there is no relationship between table my matrix is not populating correctly.
Lights should be green. I can see background value.
Can you help me with issue? How can I handle this?
Thanks,
Neha
Solved! Go to Solution.
Hello,
My issue is resolved.
Now I created sort by column in table 2 itself. So table 1 sorting table is not required anymore.
Thanks,
Neha
Hello,
My issue is resolved.
Now I created sort by column in table 2 itself. So table 1 sorting table is not required anymore.
Thanks,
Neha
Hi @nehajadhav166
How you build table 1, if you take reference of Table 2 (summarize, distinct dax function) to create table 1
May be shows error for relationship
Please create Table 1 table by inserting of data (as lookup table only)
Can you please check and confirm
Can you please share image for relationship diagram for your data model
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Proud to be a Super User! | |
I created Table 1 using excel,importing excel.
Is that issue?
In relationship model there is no connection between these two table.
Thanks,
Neha
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 46 | |
| 41 | |
| 34 | |
| 32 | |
| 23 |
| User | Count |
|---|---|
| 125 | |
| 119 | |
| 90 | |
| 75 | |
| 69 |