Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JanikSchaefer
Helper II
Helper II

Column and line chart - filter every one seperately

Hey Power Bi Guys!

I have my data like this:

 

MonthProfitactual/planned
15000planned
23000planned
34000planned
42000planned
12000actual
24000actual
33000actual
49000actual

 

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

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@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())

View solution in original post

Greg_Deckler
Super User
Super User

Create 2 measures:

 

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

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

Create 2 measures:

 

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

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
VijayP
Super User
Super User

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




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


@VijayPit's in a single table.

Much easy? Tell me more 🙂

amitchandak
Super User
Super User

@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())

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.