Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a line chart that is showing sales by region. We have 5 regions.
I would like to be able to hide regions by "unselecting" them in the legend, but I don't see anyway to accomplish that. Like how if you click on Filter you can uncheck the attributes in region and it will remove them from the line chart.
Is there anyway to do that inside the visual or using another filter to replace the legend?
The best I can manage is using a treemap visual but the formatting is limited and I can't default the behavior so that clicking on UNSELECTS the value.
Using a Filter set to "TILE" works perfectly EXCEPT.... I can't specify the color of the tile buttons. I need them to match the line/legend colors.
This CanvasJS demonstrates the desired behavior:
Hide Unhide Data Series in Chart on Legend Click | CanvasJS
Shown
Hidden by clicking DataSeries1
Is there anyway to replicate this type of functionality in Power BI?
@sasdfasdfsad I don't think it is possible, the only way is to use slicer/filter, seems like you have already explored that option.
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.