Forum Discussion

New Member

10 years ago

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...

Need Help

PowerDAX

Resolver III

10 years ago

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

pt001

New Member

10 years ago

Thanks PowerDax!!! I think the link regarding making the measure dynamic based on selection is what I'm after. I previously accomplished such functionality in Excel using a dynamic dropdown that when changed would trigger the VB to adjust the chart accordingly. I'm admittedly a novice at Power BI. How would I go about adapting the informaiton in your link to Power BI?

Thanks again,

Patrick

Forum Discussion

Dynamic Legend?

Related content

Dynamic Legend Name

Stacked column chart with dynamic legend

Dynamic y axis legend

Dynamic legend colours

Legend with dynamic data in Shape MAP