Forum Discussion
Dynamic Legend on Drilldown
Hi jtteyssier ,
I think using a field parameter is the closest solution to what you have in mind. there is no way to put multiple fields in the legend to make it hierarchical. Using the isinscope function does tell you the current hierarchy, but there is no way to put a measure into the legend.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jtteyssier ,
You can create a field parameter.
Place the parameter field in Legend and select Category Score before drilling down.
After the drill down select Sub-Cat Score.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! I appreciate the response! This is essentially where I am stuck now. I have created the field parameter, but I don't think this solution is intuitive enough for my users - they will expect the drilldown to automatically switch between Category & Sub-Cat Score.
Is there anyway to automatically set the field parameter slicer? Wondering if I can leverage ISINSCOPE for this?
Hi jtteyssier ,
I think using a field parameter is the closest solution to what you have in mind. there is no way to put multiple fields in the legend to make it hierarchical. Using the isinscope function does tell you the current hierarchy, but there is no way to put a measure into the legend.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I ended up going with a set of Bookmarks and buttons. Now, a single button press drills down and sets the filter.
Thanks for your help!