Bundesliga Team Performance

[Anonymous]

Hi all,

I'm currently working on building a soccer report, based on the German Bundesliga league that's due to start up again this weekend.

I'm struggling to get a visual that tracks a teams points as the months go on, it should be a simple line chart that goes up, however something is busted and I can't figure it out. The league table on the left is correct, which is built by a measure adding the points awarded by each team when they're away, to the points the same team scored when playing at home (both columns), however when trying to bring a date into the equation is doesn't calculate correctly.

^ See above, line graph should slowly increase to 55 points in the case of Bayern Munich, but it stops arouund 40 then declines?

I'm assuming this is relationship based as I've seperated the Home Results and Away Results to allow me to calculate Home vs Away effectiveness, but I couldn't see another way to get proper home vs away stats. Would love some help on how to build this better!

The dataset I've used to create this is downloadable here, (I chose the XLS) - https://fixturedownload.com/results/bundesliga-2019 

The PBIX file is here, please feel free to jump in, edit and send back - https://www.dropbox.com/s/m18spfm6qd3lsdu/Bundesliga%20Stats%20-%20Online%20Gateway%20Test.pbix?dl=0...

Kind regards,

Jordan 

[Anonymous]

Hi all,

Thanks for providing solutions, I ended up using my Fixtures table as a bridge and date table to fix this issue.

I set both the relationships as single, many to many, with the fixture list filtering the Home results table to avoid losing anything. I did the exact same with the Away Results column.   

I'll leave the files links intact so anyone who finds this thread can view the problem and see how the solution fixes it.

Kind regards,

Jordan 

[v-gizhi-msft]

Hi,

It is because your total team points were filtered by date.

The line chart showed commonly.

If you want to increase to 55, you can try to ingore the date filter.

Please try to create a seperate date as X axis:

Table = UNION(DISTINCT('Away Results'[Date of Game]),DISTINCT('Home Results'[Date of Game]))

The result shows:

Best Regards,

Giotto

[vanessafvg]

create one date table and link it to both of them using that date.

easy to create with 

new table

date table = calendarauto()

[camargos88]

Hi @Anonymous ,

You are having problem with your dates.

You have 2 tables (Away/Home), in this chart you are using the Away dates.

Try append both tables and using a column to separate them.