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

The 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.

Reply
elmurat
Helper I
Helper I

DAX comparison operation don't support comparing values of type Text with values of type True/False

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.

elmurat_0-1720487649476.png

 

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.

 

2 ACCEPTED SOLUTIONS

Hi,

I do not get any error when drilling up and down

Ashish_Mathur_0-1720568256674.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Hi @elmurat 
It seems that all the drills are working ok :

Ritaf1983_0-1720578273601.png

What did you try to do, that triggered the error message?

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

11 REPLIES 11
Ritaf1983
Super User
Super User

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  

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Hi @elmurat 
It seems that all the drills are working ok :

Ritaf1983_0-1720578273601.png

What did you try to do, that triggered the error message?

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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:

Ritaf1983_0-1720626714180.pngRitaf1983_1-1720626741773.png

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Hi,

I do not get any error when drilling up and down

Ashish_Mathur_0-1720568256674.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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