Hello
I'm building a clustered bar graph in Power BI, where each set of bars represents performance of a member of the team at different time periods. Problem is, while the first values show correctly, the 2nd values I add for some reason display the sum for the whole dataset, not the total for the relevant individual. Same for the third values set of values. Does anyone have any suggestions as to a fix? Or is there a video on the site I can use to learn more about building clustered graphs in PBI?
Many thanks
Ben
Hi Ben,
This will be caused by the data model relationships not being set up to support the chart you want to display. I suggest you watch session 6 of the Power Pivot course to understand how relationships should be set up.
Mynda
Thanks very much Mynda, I'll watch that one.