Forum Discussion
Random Error for Expand/Collapse for Matrix in Power BI service
Hello Team,
We are facing random failure to expand/collapse icon for matrix in Power BI Service after June 2025 update.
Steps:
1) We have created field parameter to use as rows for expand/collapse in metrics visual (i.e. Country, State, City)
2) Value is coming from measure based on selection
3) If we select country only from 1st step then matrix displays country wise sales if we select country, state then matrix have expand/collapse for Country, State wise
Problem:
Earlier it was working well but after update found issue that it's fail to expand/collapse randomly unless we remove and re-create fields for matrix.
Can you please suggest or look out this issue?
Thanks
Update: Microsoft Team Resolved issue as it was from service related error as just received update.
17 Replies
Hi jaysgovindiya ,
Thank you for reaching out to Microsoft fabric community
Try These steps to resolve -
Create a Field ParameterNavigate 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,
SreetejaThanks v-sshirivolu 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.
The same happend to us today... It was working perfectly and stopped working.
Do we know if they are going to fix it?
Thanks!Hi AAM_ ,
Yes I have raised support ticket and they are working on the fix.
Update: Microsoft Team Resolved issue as it was from service related error as just received update.
I have the same issue. I have several reports an those that have been updated and published within the last week have the issue that the +/- is not working anymore. In the ones that haven't been updated recently it is working fine.
This beahaviour I have even with visuals that haven't been changed, they were just part of the dashboard that was redeployed.Yes zsombor, Now as per update provided by Microsoft team they have fixed and it's working.
Then it seems that they fixed something else. I have several reports, the ones I did not touched the last days the +/- is working perfectly, the ones I touched are not working. I did not even touch the visualization itself just the I changed something in the PBIX file and redeployed. The problem is really severe, I have several reports that affected.
