Solved: Dynamic Legends Via Slicer

tjd · ‎02-05-2017

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?

Year Selected

Quarter Selected

tringuyenminh92 · ‎02-05-2017

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.

View solution in original post

tringuyenminh92 · ‎02-05-2017

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.

tjd · ‎02-06-2017

Obviously not as elegant and intuitive as using slicers but workable. Thanks.

danextian · ‎07-22-2017

I do think it's possible but can be a little complicated.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

jakepwills · ‎06-09-2019

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:

https://youtu.be/vTr37C4FU0I

And here is a dashboard showing it working:

https://app.powerbi.com/view?r=eyJrIjoiMjgzY2JhMWItNzIyMS00Mjg2LTljOGQtYzQyNDhlNDNiZTI4IiwidCI6IjU5M...