Hello Power Bi Community !
I am quite new to this software and am excited to learn.
I faced a problem which I can't resolve :
I am creating a Power Bi from Sharepoint list. I have 5 locations where data is entered in the week endings every week which is saved in sharepoint.
The issue I am having right now is in Power Bi where I have to compare Actual Wage and Estimated wage for which I have used LINE & Clustered COLUMN CHART.
The settings I have:
1. Shared Axis: WeekEnding
2. Column Series: Location
3. Column Values: Actual Wages
4. Line Values: Estimated Wages
The Actual wages shows all the values with respective locations but with Estimated wages it sums up the values for that entire week. I wanted Estimated wages to show the respective location entries like the Actual Wage.
The screen shot is below:
The yellow line is Estimated wages which is showing the total sum of that week ending.
I am bad at explaining, so if you want more screenshot I can provide that as soon as you ask for that.
Thank you