Im new to PowerBI and looking for some help with PayPal KPI Donut Chart. I am trying to link multiple tables of the same field into the KPI Donut Chart and then filter by Year slicer.
The KPI Donut chart doesnt seem to allow me to assign multiple tables by dragging in the normal way. It only shows 1 field from 1 table. I do seem to have linked the year slicer to the Donut Chart though.
The Year slicer is reading from an appended table of Year values from each table, leaving only 3 options; 2021, 2022, 2023
The result is that the chart shows values for Survey 2021 only and doesnt change when I click on 2022, 2023 values in the Year slicer. I would like the donut chart to show different values per year.
Tree structure showing each table linked by Employee Name in both directionsAny help much appreciated.