Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello All.
I get the above error when drilling down and back in the matrix.
The source is an Excel file, with no calculations at all. Just direct fields are being used.
It happens in the lower rows of the matrix after I scroll down the table.
Example: scroll down the matrix to Product ID FUR-CH-10002331. Drill down by clicking on the plus button starting from the Product Name until the Sub-Category column. Then drill back to the Product Name. The viz will error.
An example pbix file can be found here.
Solved! Go to Solution.
Hi,
I do not get any error when drilling up and down
Hi @elmurat
It seems that all the drills are working ok :
What did you try to do, that triggered the error message?
Hi @elmurat
Please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
how do we attach here? I don't see any button to attach.
Hi @elmurat
You can save the file in some kind of public drive and share via link.
Hi @elmurat
It seems that all the drills are working ok :
What did you try to do, that triggered the error message?
scroll down the matrix to Product ID FUR-CH-10002331. Drill down by clicking the plus button from the Product Name until the Sub-Category column. Then drill back to the Product Name. The viz will error.
Hi @elmurat
still seems ok:
Hi,
I do not get any error when drilling up and down
hi Ashish, scroll down the matrix to Product ID FUR-CH-10002331. Drill down by clicking the plus button from the Product Name until the Sub-Category column. Then drill back to the Product Name. The viz will error.
Still no error.
I'm having the same problem. If you drill down all columns, then scroll down to the bottom rows, then press '-' on a column that has more than one child, and then press '+'. The matrix crashes with this error. If you keep one record minimised (again by pressing the '-') then this does not happen when attempting with a second record
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
129 | |
78 | |
76 | |
60 | |
53 |
User | Count |
---|---|
164 | |
86 | |
68 | |
68 | |
58 |