Forum

Power BI Clustered ...
 
Notifications
Clear all

Power BI Clustered Graph summing all values?

3 Posts
2 Users
0 Reactions
61 Views
(@benr)
Posts: 6
Active Member
Topic starter
 

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 

 
Posted : 10/07/2020 10:44 am
(@mynda)
Posts: 4761
Member Admin
 

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 

 
Posted : 10/07/2020 6:49 pm
(@benr)
Posts: 6
Active Member
Topic starter
 

Thanks very much Mynda, I'll watch that one.

 
Posted : 11/07/2020 3:14 am
Share: