Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Unanswered

Power Bi two column values in one graph

(0) ShareShare
ReportReport
Posted on by

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Query

#1
ronaldwalcott Profile Picture

ronaldwalcott 2

Overall leaderboard

Featured topics