Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

TWO DATA LABELS IN BAR GRAPH

Hello friends, how are you?

 

I try to put two data labels in a bar graphic, like a pizza graphic, but i dont know how. 

 

This image show the data labels.

 

 

but in a bar graph I dont know how to put both information, someone can help me?

 

Thanks a lot 😉

 

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Create clustered line visual. Use the same y-axis for line and bar, if needed (switch off the secondary y Axis. use the secondary y Axis, if you have a number vs % column).

     

    Display line labels and make width of the line 0 using option under shapes

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Create clustered line visual. Use the same y-axis for line and bar, if needed (switch off the secondary y Axis. use the secondary y Axis, if you have a number vs % column).

     

    Display line labels and make width of the line 0 using option under shapes

  • freakinaditya's avatar
    freakinaditya
    Icon for Helper II rankHelper II
    1 year ago

    I have found solution for this

     

    Visualize the chart in the column or bar graph.

     

    Turn off the value and turn on the title in data labels.

    Expand the title and select custom on it and click on the add data.

    Create a measure that you would like to show in the data labels.

     

    Amt = FORMAT(SUM([amount]),"0")&" (" & FORMAT(SUM([quantity]),"0")&")"
     
    pass the measure on the add data. 
     
    There you go! Its working now.