Incorrect percentage pulling through to chart

[ReneeKoelewyn]

Hi,

I am trying to pull through the data for 2024, but the incorrect percentage is pulling through to the chart. 

Not sure what I am doing wrong - any assistance will be greatly appreciated. 

[Darui6 · Accepted solution]

Hi,

it seems like you have a seperate table for each year, but you use only one column for the x-Axis. Is your table for 2024 connected to the learning hub category in the data model?

As it shows the total of all categories for each category, there is probably a connection missing in your data model.

[ReneeKoelewyn]

Hi,

Thank you so much! I had to create a new relationship, done and resolved 🙂