Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gustavobinnie
Regular Visitor

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 you have in dataset 1 the list of current cars with hp and price in one dataset and in another dataset I have all past cars with hp and price. I want to select one car from dataset 1 and see in a scatter chart with all data from dataset 2. How would you implement this in Power BI?

3 REPLIES 3
gustavobinnie
Regular Visitor

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.

lbendlin
Super User
Super User

You are building a cross join, You need to add a measure to the values area to make that work.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors