Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@Anonymous , check if the first down arrow button in pressed. In the set of drill down and expand button you have.
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.
@Anonymous , check if the first down arrow button in pressed. In the set of drill down and expand button you have.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |