Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
@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
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
Proud to be a Super User!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.