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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.