Forum Discussion
Helper IRandom Error for Expand/Collapse for Matrix in Power BI service
Update: Microsoft Team Resolved issue as it was from service related error as just received update.
Hi jaysgovindiya ,
Thank you for reaching out to Microsoft fabric community
Try These steps to resolve -
Create a Field Parameter
Navigate to Modeling - New Parameter - Fields.
Select Country, State, and City.
This will generate a parameter table (such as LocationParam).
Create Matrix Visual
Add a Matrix visual to your canvas.
Drag LocationParam[Field] into the Rows area.
Add the [Sales] measure to Values.
Add a Slicer
Insert a slicer using LocationParam[Name].
Enable the multi-select option.
You can select:
- Only Country
- Country and State
- Or all three levels
Test Expand/Collapse
If multiple levels are selected (like Country and State), the expand/collapse (+/-) icons should appear.
Try expanding a Country row to display its States.
Please find the attached .pbix file for your reference.
Regards,
Sreeteja
jaysgovindiyaThanks Anonymous for sharing insights I have created in same way but if we add Clear all slicers button in same and publish in service at that time it's behaving randomly after clear all slicers as not able to expand in Power BI Service.
Hi jaysgovindiya ,
Rather than using “Clear all slicers,” use a reset bookmark to restore the default slicer settings, such as having Country and State pre-selected. This helps maintain the internal link between matrix rows and field parameter selections.- jaysgovindiya
Thank you again provided work around unfortunately that is also not working as earlier it was working fine.