Display selected items in line & clustered column chart
Hello, good day, is there a way to show the line value based on my selection? For example, if I select the trainee option, the line value will ony display my trainee target. At the moment if I use a slicer, the line value will show as below eventhough the clustered chart will change accordingly to my selection. Been stucked for 2 days. File will be attached below. Thanks.