Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Divided Running total without names

Hello. I am new to power BI. I am trying to include a Line in my line Chart that adds up the total of all Workers and Divides them by Worker number so that I can see how much each worker should have...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could remove the legend fields. Then create measures for each Name and create a average measure.

    Put these measures in "Values".

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Share some data and show the expected result in a simple Table.  Once the Table is ready, you should be able to create line chart.