Forum Discussion
Solved
Auto click/expand Row Header +- icons
I have a matrix report in Power BI desktop as such. It has 2 rows, the second of which has to be expanded by clicking the Row Headers +- Icon. The issue being when new rows are added...
Reached out to Microsoft support who revealed the secret to this.
What you need to do is right click on any random row under your first Row Header and there should be a menu option for 'Expand'. If you select ALL here, any new rows that get added to the report will get auto expanded.
andyor , If you have used the expand icon near three dots expanded next level and saved the report at that point, it should remain expanded
Sorry Amit what do you mean?
I have a Matrix, with 2 rows. That icon is greyed out.
How would what you're saying work for new rows that get added to the dataset?