show multiple lines in line and clustered column chart

[Anonymous]

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 :

The issue I am having right now is I have to compare Actual Wage and Estimated wage for which I have used LINE & Clustered COLUMN CHART.

The settings I have:

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

[Greg_Deckler]

@Anonymous Well, you could create three measures, one for each location and use those in the field well for Line values. Or, perhaps a stacked line and column chart would be better?

[Anonymous]

@Greg_Deckler

Thank you greg for the reply but I didn't quite get what you are referring to. As I am new to the Power Bi Sorry for not understanding the solution.

[Greg_Deckler · Accepted solution]

@Anonymous Well, let's say you have a column called Estimated Wages. You could create these three measures:

Location1 Estimated Wages = CALCULATE(SUM('Table'[Estimated Wages]),[Location]="Location1")

Location2 Estimated Wages = CALCULATE(SUM('Table'[Estimated Wages]),[Location]="Location2")

Location3 Estimated Wages = CALCULATE(SUM('Table'[Estimated Wages]),[Location]="Location3")

Place all three of these measures in the field well where you currently have Estimated Wages.

[Anonymous]

Hi @Greg_Deckler ,

The formula worked. As a new user I was doing something different.

Thank you so much for your help!

[Anonymous]

Hi @Greg_Deckler ,

According to my understanding we have to create new columns with the given function and drag the newly created columns in the Line Values.

And in my scenario I have all the locations in one Column. When I tried to implement the given formula the new column output is empty.

[Greg_Deckler]

@Anonymous It's hard for me to say. You can put multiple measures into the Lines values field well but I don't know your data enough to be able to tell the exact solution.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

Hi @Greg_Deckler ,

Thank you for the reply. I tried to do with another location and it's working and when I try to create a new measure it comes up with a circular dependency was detected.

[Greg_Deckler]

@Anonymous What is the formula for your measure?

[Anonymous]

Hi @Greg_Deckler ,

Formula:

Location1EstimateWage = CALCULATE(SUM('Beginning Report'[EstimatedWages]),'Beginning Report'[CenterLocation]="LocationName")

[Greg_Deckler]

@Anonymous Is Estimated Wages a measure or a column? If it is a measure, lose the SUM. Also, if Estimated Wages is a measure, what is the formula? If Estimated Wages is a calculated column, what is the formula?

[Anonymous]

Hi @Greg_Deckler ,

The Estimated wage is a Column and it doesn't have any formula. And I have only one table everything is in the same table.

And also I wanted to ask. Can we do this instead of multiple lines.

Which helps the users to see whats happening on their location.