Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Show data label only to one line

Hello

 

As attached below, I want to know if is it possible to show data labels only for one line in a line chart ?

What I can do is just changing the form or adding markers but data labels when activated are showed for all lines.

 

Thanks

  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous - You can accomplish this by doing the following:

    1. Creating a separate measure for each item in your legend, like calculate(<measure>, <legendtable>[legendcolumn] = "legend value")

    2.  Remove the legend and the current measure from the line chart.

    3. Add all of the measures to the line chart.

    4. Then Data Labels will have the Customize Series option.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous  - Yes, you can, by doing using Customize Series. It will allow you to format each line individually:

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous I want to show data labels not change shapes, I didn't find customize series below labels 

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous - You can accomplish this by doing the following:

        1. Creating a separate measure for each item in your legend, like calculate(<measure>, <legendtable>[legendcolumn] = "legend value")

        2.  Remove the legend and the current measure from the line chart.

        3. Add all of the measures to the line chart.

        4. Then Data Labels will have the Customize Series option.

    • MWithrow's avatar
      MWithrow
      Frequent Visitor

      Anonymous wrote:

      Anonymous  - Yes, you can, by doing using Customize Series. It will allow you to format each line individually:

       



      This solution worked for me.  Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable

        This is a bit of a hack but you can make a copy of the graph so you have two identical graphs (make sure both the x and y axis are fixed to the same min/max). On one graph remove all of the lines you don't want to display the data and turn data labels on for this graph. On the second graph remove all of the lines you do want with data. If you then overlay them then you'll have the desigered effect.

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous ,

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

     

    Regards,

    Daniel He