Forum Discussion
adding external data to line chart
I have a database of students, each one of whom has a boolean flag indicating whether they are a young carer.
I have created the following DAX formulae:
Access Young Carer = CALCULATE('Access metrics'[Access], 'Access Data'[Young Carer] = 1)
Access Young Carer PC = divide(CALCULATE('Access Metrics'[Access Young Carer]), CALCULATE('Access metrics'[Access]))
to enable me to create a line chart, with year as the axis, showing year on year percentages of young carers.
I also have the following (manually altered) external data, showing the percentage of young carers in our local area:
Year Care Leaver %
2016 1.01
2017 1.09
2018 0.97
2019 1.13
2020 1.09.
How can I add this external data to my line chart? I need to show a direct comparison between our young carers, and the local population.
2 Replies
Create a Measure CALCULATE(Sum(External Value), Values(Yearin main Table), Year in External Table)
and this measure you can add to the Chart and it will be considered for report.
Please share your Kudoes and please mark this a solution if you find this as solution
also you can watch my videos at www.youtube.com/perepavijay
AJPF , based on what I got you to need to have common year dimension and you use this column as a line with some aggregation
