Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 , I doubt you can change measure based on clicked measure name
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?
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.
Thanks. I'll do further research on how to accomplish this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |