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 Champion
Measure = SUM('Table'[# Complete]) / SUM('Table'[Eligible Employees])
The issue with this is that [#Complete] and [Eligible Employees] are measures not columns so this won't work i believe.
# Complete = DistinctCount(SurveyData[ID])
Eligible Employees = CountRows(HeadcountData)
v-frfei-msftCommunity Support
Hi 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