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
Where do I put this measure?
As you can se below:
I have YEAR om my axis, then the AREA (which is in i slicer that my user can choose one area from) and the my value (from a column i my datatable) that is growth in percentage. Where do I put the measure?