Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
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!
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.
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