Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Tribal
Frequent Visitor

Unable to locate error - simple hierarchy

Currently some of my slicers are returning an error. I've been trying to locate the error, but I'm not sure what "Query (14, 55)" or "Query (11, 55)" is referring to here, and therefore I have no clue where to look. The slicer is using a simple year-month hierarchy, where both year and month are text values, which is therefore adding to my confusion, since the mentioned function 'CONTAINSROW' doesn't seem relevant for this field.

 

I hope someone can point me in the right direction

 

Tribal_0-1698066241115.png

Tribal_1-1698066425632.png

 

 

2 REPLIES 2
mh2587
Super User
Super User

I think you are facing data type error in one of measure 


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Tribal
Frequent Visitor

I agree, that's what it looks like, but also where my confusion is. The slicer I'm using is not using any measures, but only a hierarchy text field. 

Tribal_0-1698067048658.png


That makes it alot harder to look in the correct location. My guess was that the numbers in brackets (14, 55) are referring to where the error is coming from, but I don't know how to interpret these numbers unfortunately

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors