Power Bi two column values in one graph

Question

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 &amp; Clustered COLUMN CHART.The settings I have:1. Shared Axis: WeekEnding2. Column Series: Location3. Column Values: Actual Wages4. Line Values: Estimated Wages&nbsp;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

ba_pete · Answer

Hi&nbsp;Syndicate_Admin&nbsp;,&nbsp;Anonymous&nbsp;,
&nbsp;
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.
&nbsp;
Pete

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
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

&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v
&nbsp;
&nbsp;

Forum Discussion

Related content

Splitting Column values

Matching Column Values

Check column for similar values

Power BI selected (marked) value in new column

Find MAX Value within a column