Forum Discussion
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...
Hi Anonymous ,
You could remove the legend fields. Then create measures for each Name and create a average measure.
Put these measures in "Values".
Thats the look that I want. Unfortunatly that would mean I have to sacrifice the chart bein dynamic as I would have to add a new worker each time, right?
I think I will still go this way as it represents the data the best and I am in a lucky position at the moment where I dont exactly need it to be dynamic. But nontheless it would be nice.
Thank you.
Hi Anonymous ,
Yes, every time you add a name, you need an extra measure.
Currently you could also use constant line to get average value but it is always static. You could vote for the following ideas about dynamic constant line ot improve Power BI.