Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total column in graphics

Hello everyone!!

 

I have data from diferent groups, lets say: Group 1, 2, 3, 4.... If I made a table in visuales it gives me back the "total" or "average" of all the groups. Is it possible to add this "total" or "average" in a column chart??? It would be perfect if it can appear as a sepparate column in the graphic with the other columns of Group 1, 2, 3.... to compare them visually. Thanks in advance!!

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    Take "total " for example, you can create a measure such as below:

     

    Measure = SUMX(ALL('Table'),'Table'[Consumption])

     

     Then put the measure in the "value " field of a clustered column chart,and you will see:

     

    The same with "average",here is a sample .pbix file you can refer to.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Hello! Thank you but is not what i need. I want to add that average with the other groups in a column chart, is that possible?
      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        Take "total " for example, you can create a measure such as below:

         

        Measure = SUMX(ALL('Table'),'Table'[Consumption])

         

         Then put the measure in the "value " field of a clustered column chart,and you will see:

         

        The same with "average",here is a sample .pbix file you can refer to.

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!