Forum Discussion
Field Parameter Question
Yes, this is doable with one field parameter. Create a parameter that contains all six fields (Manager, Supervisor, Employee, State, City, Street), then drop the parameter into the Rows well of your matrix.
On the field parameter slicer, turn on multi-select. When the user picks the three fields they want, the matrix shows them as a normal row hierarchy with the usual expand and collapse icons.
Use the Order column in the parameter to lock the display order so Manager, Supervisor, Employee and State, City, Street always appear top-down even though they share the same slicer. If you want a single click toggle instead of three checkboxes, layer two bookmarks over the slicer, each preselecting the right three fields.
If this solved it, please mark it as the accepted solution and give it a kudos.
Thanks,
Shai KarmaniJust ensure to turn on Persist hierarchy level from the options
Yes, this is doable with one field parameter. Create a parameter that contains all six fields (Manager, Supervisor, Employee, State, City, Street), then drop the parameter into the Rows well of your matrix.
On the field parameter slicer, turn on multi-select. When the user picks the three fields they want, the matrix shows them as a normal row hierarchy with the usual expand and collapse icons.
Use the Order column in the parameter to lock the display order so Manager, Supervisor, Employee and State, City, Street always appear top-down even though they share the same slicer. If you want a single click toggle instead of three checkboxes, layer two bookmarks over the slicer, each preselecting the right three fields.
If this solved it, please mark it as the accepted solution and give it a kudos.
Thanks,
Shai Karmani