Forum Discussion
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...
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:
Please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983
Super User
Super UserHi 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:
Please consider Accepting it as the solution to help the other members find it more quickly