Forum Discussion
Combine 2 datasets into chart without prior join.
I have two datasets and I want to select one row from dataset 1 dynamically (from a slicer) and join with the dataset 2 and put both series into a chart and highlight the data from dataset 1. Imagine...
But how would do this cross join into a new table that can change depending on the slicer? So the cross join only gets one row from dataset 1 and all rows from dataset 2.
Ah, so you want to append, not join. Use UNION.
