Forum Discussion

Rasmus7700's avatar
Rasmus7700
Frequent Visitor
2 years ago

Values from two tables and filtering?

Hello Guys.  I'm trying to build a dashboard from Business Central data - and thouht i allmost was there - but then i hit the head to the wall again - hopefully you guys can help me out here...    ...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi Rasmus7700 ,

 

It's seem to be an issue with the relationships between the two tables. How are the tables related?

Rasmus7700's avatar
Rasmus7700
Frequent Visitor
2 years ago

Mhhh.. Could be 🙂 

The two tables only have relationship between the "Job Number" and "Job Number and Description" - not all the other fields shown in the Pivot as "Rows".... 

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.

    • Rasmus7700's avatar
      Rasmus7700
      Frequent Visitor
      2 years ago

      Just send a PM with DL Link... The Relation problem lies between the table "Sager - Sagsposter Raliseret" and "Sager - Sagsplanlægningslinjer (Budget) - visualized on Page 1 🙂