Power Bi Matrix

[Anonymous]

Hi community,

I am currently having a problem in regards to a matrix table every time i attempt to add in a new field it is drilling down. Is there anyway to prevent this so that information stays on the present table and does not drill down?

[v-henryk-mstf]

Hi @Anonymous ,

According to your question, this is my help: for matrix table, every time you add a field to row, there will be a drill down, one more level. Please note that when you expand the level of a row, add a field to row at this moment, and then the matrix will expand all the data of the previous layer, as shown in the figure. If you don't want to expand all the data after adding a field, please don't expand any row of the previous layer before adding a field. Take a closer look at the screenshot below for comparison.

If any row in the matrix is not expanded before adding a field, the current state is maintained.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , check if the first down arrow button in pressed. In the set of drill down and expand button you have.