Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Show Two Lines on the same Chart from same Column in Power BI Desktop

I was trying to show two values from a same column on the same Lines Chart, but cant find a simple way to do it. I have a Table like this: DateTeamValue 01/02/2023 Team 1 0 03/02/2023 Tea...
  • Ritaf1983's avatar
    3 years ago

    Hi Anonymous 
    You can achieve your goals in 2 ways :

    1. just put your team to a legend :

     

     

     


    2 create measures for every team, like :

    Total team 1 = CALCULATE(sum('Table'[Value]),'Table'[Team]= "team 1")
    Total team 2 = CALCULATE(sum('Table'[Value]),'Table'[Team]= "team 2")

    and than put both of your measures on Y axis:

    Link to the sample file 

     

    Please consider Accepting it as the solution to help the other members find it more quickly