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 viewed/read the article on Dynamically change the information within a visual via a slicer and have put the technique to good use. However, I now need to have a clustered column chart in which I can dynamically change the legend from one category to another (see below). The dynamic changing approach above does not work with legends as they do not accept measures, only column names. Any ideas on how to use a slicer to dynamically change the Legend value?
Solved! Go to Solution.
Hi @tjd,
So far, i dont think it's possible to achieve, but you could introduce for end-users drill-down with hierarchy buttons in the top left of charts.
Hi @tjd,
So far, i dont think it's possible to achieve, but you could introduce for end-users drill-down with hierarchy buttons in the top left of charts.
Obviously not as elegant and intuitive as using slicers but workable. Thanks.
Proud to be a Super User!
I know this thread is old... but just incase there are others like me that were searching for a solution and found this first, I thought I'd share how to get around this.
It involves making a new table with a CROSSJOIN... I've made a video showing how to do it here:
And here is a dashboard showing it working:
This should be the selected answer... Thank you
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |