Forum Discussion
Solved
create a bar chart with an average line running through
Hi All, I am trying to create a bar chart with an average line running through. The matrix button works as below:- [CODE] Function % Complete Function 1 54.50% Function 2 40.00% ...
Hi Forrestgump,
For column chart, we can only add the measure as a Min line in the Analytics pane like this.
Measure = CALCULATE(DISTINCTCOUNT(SurveyData[id]),ALL(SurveyData))/CALCULATE(COUNTROWS(HeadcountData),ALL(SurveyData))
For more details, please check the pbix as attached.
https://www.dropbox.com/s/g56davhns5i6kt1/create%20a%20bar%20chart.pbix?dl=0
Regards,
Frank
v-frfei-msft
Community Support
Community Support
Hi Frank,
Sorry what i mean is a bar chart not a column chart but there doesn't seem to be an option for a bar chart for line and clustered bar chart?