Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

stacked area chart

hi i want to show the sum of all points on the stacked area chart when hovering, and not only the value of each point, is it possible?   thanks!
Need Help
Habib's avatar
Habib
Icon for Continued Contributor rankContinued Contributor
10 years ago

You should add new measure to calcuate sum for All values and then add that as tooltip.  Below is an example

 

TotalSales = SUMX(ALL(Sales),Sales[Sales])

 

Below screenshot can help

 

  • MP_123's avatar
    MP_123
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

     

    thank you! but see the print screen: my problem is that in area chart, the tool tip has added to each point, and i want it only once

    • Habib's avatar
      Habib
      Icon for Continued Contributor rankContinued Contributor
      10 years ago

      I have replaced chart o Area and can see below. Are you adding other attribute to Legends?

       

      • MP_123's avatar
        MP_123
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        i can't add the new measure to the legend. (disabled)

        so it just the areas there

    • Eric_Zhang's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      MP_123

      The toolip shows that way by design. AFAIK, there's no way to show only one toolip when the legends have more values.

      Check if below workaround acceptable or not. Put the totalsale measure to a Card visual and drag the Card visul to a blank space in your stacked area chart.