Column and line chart - filter every one seperately

[JanikSchaefer]

Hey Power Bi Guys!

I have my data like this:

Month	Profit	actual/planned
1	5000	planned
2	3000	planned
3	4000	planned
4	2000	planned
…	…	…
1	2000	actual
2	4000	actual
3	3000	actual
4	9000	actual

no I want to make a column and line chart (x-axis is month, y axis profit) and the colums show the actual values while the line shows the planned value.

is there a way to do this easily? If I set a filter on "actual", it affects the whole visual, can I just filter the line/columns?

Thanks guys!  🙂

Cheers,

Janik

[amitchandak · Accepted solution]

@JanikSchaefer , Did not get completely

But this should work as measure

planned=calculate(sum(table[profit]), table[actual/planned]="planned")
actual=calculate(sum(table[profit]), table[actual/planned]="actual")

and these a new columns

planned=if( table[actual/planned]="planned",table[profit], blank())
actual= if( table[actual/planned]="actual",table[profit], blank())

[Greg_Deckler · Accepted solution]

Create 2 measures:

Measure 1 = SUMX(FILTER('Table',[actual/planned] = "planned"),[Profit])

Measure 2 = SUMX(FILTER('Table',[actual/planned] = "actual"),[Profit])

[VijayP]

is the data in same table or two different Tables? If you Keep this in single table you can do much Easy!

[JanikSchaefer]

@VijayPit's in a single table.

Much easy? Tell me more 🙂

[amitchandak · Accepted solution]

@JanikSchaefer , Did not get completely

But this should work as measure

planned=calculate(sum(table[profit]), table[actual/planned]="planned")
actual=calculate(sum(table[profit]), table[actual/planned]="actual")

and these a new columns

planned=if( table[actual/planned]="planned",table[profit], blank())
actual= if( table[actual/planned]="actual",table[profit], blank())