Looking for some pointers for porting Excel charts over to Power BI

Hi,

I've been dabling with PBI for around 8 years now and I've not really acheived anything that's made we want to mover over from Excel.

I'm just in the middle of a 'trying again' phase 😂

I tend to build some good looking charts in Excel and think that it'll be simple to re-create them in PBI but I get the data into PBI and can't seem to make it work.

This is an example of something that I'm working on now...

In Excel I've built the following chart...

...It does what I expect it to do.

It comes from a Pivot table that looks like this...

This comes from a SQL view that looks like this...

When I import the SQL view into PBI I cannot figure out how to get this to work on a 'Line and Clustered Column Chart'.

Do I need to build a table that takes the SQL data and transforms it into a table that looks like my Excel Pivot Table?

If so, should I do that in PBI or SQL?

Thanks.