Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @manish94 ,
Maybe you can try to use the clustered column chart. The settings you can set as
1. Axis: WeekEnding
2. Legend: Location
3. Values: Actual Wages and Estimated Wages
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v
Hi @Syndicate_Admin , @manish94 ,
This visual won't split the line component into separate locations for you. There may be something on the Marketplace that does what you want but, to be honest, I don't think the result is going to be very clear to the end user with so many columns and lines all over the place.
I your scenario, I would recommend moving [Location] into the Small Multiples section so you have a separate axis-aligned chart for each location. This should make it far clearer, and easier for the end-user to digest the information.
Pete
Proud to be a Datanaut!