Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Problem Linking 2 Factual Sheet

Hi,

 

I'm creating a table wherein every project will show its own corresponding debtor and creditors with their respective invoices.

 

I create a bridge but when i entered the invoices i had this error. Can anyone help me solve this problem? I uploaded the file using the link provided.

 

//NT

 

https://file.io/mixmx0p6kpFE

 

tksnota_0-1721009107342.png

 

5 REPLIES 5
Ashish_Mathur
Super User
Super User

No file at that link.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi,

 

Please try this link...

 

//NT

 

https://file.io/Pvz3tYmmEdGq

Hi,

I do nto see any error when i open the file.  Furthermore, i do not see any invoice column in any of the tables.  Not sure of what you want but i think you should create another table with all uique invoices and create a Many to One relationship (from Debtors and creditors) to this new invoices table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi,

 

Apologies the invoice number is called faktuurnr

 

tksnota_2-1721116931948.png

When I try adding 2 faktuurnr/invoices into the table representing the debtors and creditors, I got this error.

 

tksnota_0-1721116814036.png

 

I uploaded the file again using this new link - https://file.io/wdlFPrDG3DPP

 

//NT

Please implement the second sentence of my previous message.  To the visual, drag invoice number from the newly created table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

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.