One Visual from 3 different tables.

[jcastr02]

I want to create one visual for # sold by month of each Product A, B, C (each of these are on seperate tables in PQ).  Each table has a Created Date column.  Is the best approach to append each of those tables together or is there an easier way to get to visual.

[FreemanZ · Accepted solution]

hi @jcastr02 

field parameter can do the trick as well

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

[Ashish_Mathur · Accepted solution]

Hi,

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

[Anonymous · Accepted solution]

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.
 

[Ashish_Mathur · Accepted solution]

Hi,

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

[FreemanZ · Accepted solution]

hi @jcastr02 

field parameter can do the trick as well

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