How to make line chart title and measure change dynamically based on table values filter

[Anonymous]

I have a table and line chart. I need the line chart title to dynamically change based on the values clicked in the table e.g. #1 looking at the first row, (under the measure 'Inside_Hours') if I clicked on "9.25", I would like the line chart to display the 'Inside Hours' measure and the chart title to display "X Branch Inside Hours by Date"

The same will apply to other columns e.g. #2 if I clicked on "-921%", then the line chart should display the 'Inside Productivity' measure and the chart title should display "X Branch Inside Productivity by Date".

Hope that made sense. Appreciate any help thanks.

Here's sample pbix file >> https://drive.google.com/file/d/1rSy29PmC-GlqORl26PzBghtNsMxWKvCe/view?usp=sharing

[amitchandak]

@Anonymous , I doubt you can change measure based on clicked measure name

[Anonymous]

That's interesting coz the same visuals work in Excel report but with custom VBA. I understand it's not a fair comparison but I presumed something similar could be archieved in PowerBi. 

@tamerj1 @AlexisOlson any advice/tips? 

[AlexisOlson · Accepted solution]

I think might be possible if you make a single measure that switches between all the metrics and create a dimension table with all the metrics to use as filter context and title.

[Anonymous]

Thanks. I'll do further research on how to accomplish this.