Appended Queries columns data not merging

[mgusty33]

I have Query A which has more columns, but all columns of Query B. However when I append the two, the new query shows it combined correctly, but then when I try using a visualization, only the data from Query A shows up. 

I need all of the data for the specific column to show up when I make a list of the contents in the column. 

[SamLester]

Can you try to enable the "show items with no data" on the column in the visual that aren't being displayed?

Thanks,
Sam Lester (MSFT)

[mgusty33]

That worked if I was just making a list. However it did not work for making a line graph or filtering. I am trying to make it column 1 vs column 2, both which have complete data from both the queries. 

To explain it as an example, I have car sold in what month from dealer one in one query, and dealer 2 in the other. Combined it to an overall "Sales" query to make a line graph to show the trend of cars per month, but only 1 dealer's data is showing up, even though I am taking everything from the "Sales" query. 

[v-jiascu-msft]

Hi @mgusty33,

Are there any duplicates? Please share a dummy pbix file. It should work according to your description.

Best Regards,

Dale