How to create a cluster column chart by joining 2 tables

[saipawar]

Hi

I am pulling data from 2 tables 

Table 1 - "plan"

Team	Activity	Cost
A	Webinar	100
A	Podcast	150
A	Video	25
B	Webinar	50
B	Paid Media	200

Table 2 - "actual" (this table does not have  activity and team broken down into unique columns. 

Program	Cost
Ops - A- Webinar	25
Ops - A - Podcast	300
Ops - A - Video	5
Ops - B - Webinar	10
Ops - B - Paid Media	350

I would like to creata a cluster chart showing 'plan' vs 'actual' for each activity. Team names are filters on the dashboard. How can I parse out initial text from table 2 such that I can group these activities by Team ?

Thanks

[TheoC · Accepted solution]

Hi @saipawar 

You can use Power Query very easily to achieve this.  Just go to either Transform or Add Column (use Add Column if you want to keep original column) and then click on Extract "After Delimiter" like below. Add the "-" and click okay.

Once you have done the above, you can use "Trim" in the "Transform" tab under "Format" to clean up any blank spaces.

Hope this helps 🙂

Theo