Forum Discussion

KristianHamlin's avatar
KristianHamlin
Frequent Visitor
7 years ago
Solved

How do i add 2 Line values within a Column and Line chart?

I have a simple bar chart where i have 2 years that i am comparing next to each other   ie January to December and then bar column for for each month for 2018 and one for 2019 lets say this is show...
Need Help
Tips and Tricks
  • calerof's avatar
    calerof
    7 years ago

    Yes. One for current year:

    Job Volume = COUNT( [Fact] )
    Job Volume LY = CALCULATE(
                                              [Job Volume],
                                             SAMEPERIODLASTYEAR( [Date] )
                             )

    Regards,

     

    Fernando

     

KristianHamlin's avatar
KristianHamlin
Frequent Visitor
7 years ago

Are you suggesting that i need to add a measure into my job volume data, one measure for job count for 2018 and then a second measure for job count 2019?

 

I am fairly new to using power bi so learning all the time, havent really had the need for dax measures prior so a little out of my depth at the moment if this is the only solution to be able to get 2 lines for my job counts based on the 2 calander years.

calerof's avatar
calerof
Impactful Individual
7 years ago

Yes. One for current year:

Job Volume = COUNT( [Fact] )
Job Volume LY = CALCULATE(
                                              [Job Volume],
                                             SAMEPERIODLASTYEAR( [Date] )
                             )

Regards,

 

Fernando