Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello, I've been having some trouble figuring out how to do expand and collapse on row headers of my custom matrix visual.
I've followed the guide on your docs here but buttons don't all work.
I'm rendering a button for nodes where node?.isCollapsed != undefined, meaning it should be expandable/collapsable. However, I cannot get this to work for deeper levels than the first. Comparing the default matrix visualization, the buttons are rendered correctly. Therefore I suspect it has something to do with the creation of SelectionId of the inner rows. This is where I just can't figure anything out because the documentation on SelectionId for matrices is lacking.
In image, button for "Resultat" works, "Driftsresultat" within does not.
Can I get some help identifying the issue? Debugging selectionId is not fun, wish its api was open.
Thanks for timely response,
Having re-read the docs and gone over and made sure I had everything configured correctly, I've gotten no closer.
Here are the selectionIds of rows "Resultat" and "Driftsresultat" respectively from initial post.
{
"deepestNodeLevelInPath": 0,
"measures": [],
"dataMap": {
"Plan.Lv1": [
{
"identityIndex": 14
}
]
},
"nodeIsCollapsed": false,
"nodeIndexes": [
1
],
"key": "{\"Plan.Lv1\":[{\"identityIndex\":14}]}[]"
},
{
"deepestNodeLevelInPath": 1,
"measures": [],
"dataMap": {
"Plan.Lv2": [
{
"identityIndex": 9
}
]
},
"nodeIsCollapsed": false,
"nodeIndexes": [
1
],
"key": "{\"Plan.Lv2\":[{\"identityIndex\":9}]}[]"
}
Maybe there's something I missed.
I've found I can drill down using the context menu but not my buttons. They both receive the same selectionId for the row so I don't understand why they don't behave the same...
Hi @stian_r
- Verify that your data hierarchy is correctly defined and that each level of the hierarchy is properly configured. The expand/collapse functionality relies on a well-defined hierarchy.
- Ensure that the SelectionId for each node is being created correctly. The SelectionId should uniquely identify each row in your matrix, including the deeper levels.
If you need more info please go through this accepted solution by CST - Solved: expand collapse for column matrix - Microsoft Fabric Community
Thanks!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!