Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Power Bi two column values in one graph

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

manish94_0-1630477897424.png

 

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:

manish94_0-1630477725952.png

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

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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