1 Reply Latest reply on Aug 4, 2017 11:20 AM by Ben Neville

    How to mark points on three years

    Alex Martino

      I have a three year line chart. How can I do the following things?

       

      1) Place marks on July of each year (or better stated for each year, have the label show up for the month with the max value)

      2) Have the average line for each year. Is this possible?

      3)

        • 1. Re: How to mark points on three years
          Ben Neville

          How does the attached work? Just put Year and Month in your rows, your measure on Columns and on Text, then turn on labels. Select Label Min/Max, and you should see more options appear below. You can choose to just label max, and then Pane to make sure only the max within each year is labeled. Depending on your view, you may need to use a calculation to do this, as the labeling only works in this way if things are clearly partitioned.