Forum Discussion
jeseng
5 years agoHelper III
Comparing line chart
Hi, I have a line chart, my users choose an area from a slicer. The line chart then shows the population growth for this area. What I want is to show a second line, an other area (Göteborg) to comp...
Tahreem24
5 years agoSuper User
jeseng ,
Create a measure like below for a constant line:
Measure = CALCULATE(SUM('Table'[Growth]),FILTER(ALL('Table'),'Table'[AreaName]="Göteborg"))
jeseng
5 years agoHelper III
Hi again,
When I removed the variable from "legend" I was able to put my measure in "values". The thing is, I dont want a constant line 🙂 I want to show the values for "Göteborg" as well as one more area, which my user can select from a slicer. My user also chooses Age and Gender in slicers.