Power Bi two column values in one graph

[Syndicate_Admin]

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

[Anonymous]

Hi @Anonymous ,

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

[BA_Pete]

Hi @Syndicate_Admin , @Anonymous ,

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