One Visual from 3 different tables.

hi jcastr02 

 

field parameter can do the trick as well

 

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

Hi,

If all 3 are Sales Tables, then append them in Power Query first.

Thanks for the reply from Ashish_Mathur  and FreemanZ , please allow me to provide another insight:

Hi, jcastr02 

I have two solutions to address your requirements:

 

1.Firstly, establish a direct relationship between the three tables using the Created Date column.
For example:

Here are the final results:

For further details, please refer to the documentation.

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

2.Secondly, you can also use a merge query in Power Query:

Here are the final results:

For more information, please consult the documentation.

Append queries - Power Query | Microsoft Learn

 

Please find the attached pbix relevant to the case.

 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.