Forum Discussion
create a bar chart with an average line running through
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
Community SupportHi Forrestgump,
Here I made one sample for your reference.
1. Create the measures as you offered.
# Complete = DistinctCount(SurveyData[ID])
Eligible Employees = CountRows(HeadcountData)
2. Then create a measure using the formula and create a Line and stacked column chart to work around.
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
Hi Frank,
That worked great.....However the bar chart I wanted to create runs from right to left. Is there a way of achieving this?
Regards,
Forrest
- v-frfei-msft
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?