Forum Discussion
Dynamic Legend?
Hello, Is it possible to enable the viewer of a report and/or dashboard tile to dynamically change the legend? For instance, let’s say I have a pie chart of client interactions. I know how to ena...
Hey Patrick, this is not too difficult but the feasibility depends on the size of your data. The Power Query functionality makes it a
lot easier though. Here is a great writeup example of doing just that:
http://sqljason.com/2013/01/row-selection-using-slicers-in.html
You can also make your measure dynamic based on selection:
http://sqljason.com/2012/11/measure-selection-using-slicers-in.html
Nice solution PowerDax!