Forum Discussion
Dynamic legend (not axis)
Hi All, I have seen a lot of stuff out there on dynamic axis ( ie. replacing total sales with total expenses or total profit using a switch true statement)
That is not what I am focused on. What I am trying to solve for is a process to prevent using a bunch of bookmarks and buttons to show and hide charts. I almost think of having a control table that then has a slicer that has the buttons below in as a filter which controls the legend.legend
for example look at this:
these are the buttons
mix
that control the visual channel for example
channel
legend example for channel! should be dynamic and allow user to use a drop down list.
this will remove the need or a minatance nightmare with bookmarking.
3 Replies
Take a look at this blog post: https://prathy.com/2018/12/dynamic-legend-in-power-bi-visual-linechart/
It sounds like that is what you are trying to accomplish. This is the method I have used to create a slicer that my users can use in order to change which level of the hierarchy they will see when looking at a visual.
almost but not quite! it will need to handle groupings fo example we would have channel and there would be two selections. if I picked product it would be a legend for say 4 different products bu the legend itself would be using the product field or the channel field I hope that makes sense!
Hi mws5872 , did you solve this in the meantime?
