Forum Discussion
AlonCarmel
4 months agoFrequent Visitor
Dynamic Legend Switch: Toggling between Detailed and Aggregated views without Bookmarks
Hi everyone, I’m trying to implement a toggle in my Power BI report that allows users to switch the granularity of a Stacked Column Chart's Legend. I want to avoid using Bookmarks because I have sev...
tharunkumarRTK
4 months agoSuper User
If I understand your requirement correctly, then the easiest way to achive your requirement is through a custom column or by creating a group column
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning
I would suggest you to create a custom column in power query which categorizies 8 individual categories in 3
Create a field parameter table with the actual column and also the custom column. Place the field parameter column in to your visual. Then you will be able to switch between the summary view and detailed view.
Hope this answers your question
Connect on LinkedIn
You can read my blogs here: https://www.techietips.co.in/
|