Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
stian_r
Regular Visitor

Custom Matrix Visual - Expand/collapse row headers problems

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.

 

stian_r_0-1738703563829.png

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.

3 REPLIES 3
stian_r
Regular Visitor

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...

suparnababu8
Super User
Super User

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!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors