Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

TayTay

Matrix Errors When Collapsing Column

Submitted by on ‎08-15-2024 09:21 PM

This is a repost from the Desktop forum as I think it might be an issue. My apologies if that's not allowed.

My PBI Desktop version is 2.131.1203.0 64-bit. The same behaviour is also happening in the online service if I publish.

 

I've got a simple table that I'm displaying in a Matrix, if I expand then collapse a column the matrix errors and is not displayed.

 

The table query has two custom M columns, one is quantity and the other unit.

Blank and errored quantity is removed. There are no other transformations and no DAX columns or measures.


Item Number, Unit, Type and Warehouse are all formatted as text, Quantity is a decimal number and Physical Month is a date.

The Matrix visual is collapsed on Type to show overall quantity.

TayTay_0-1723781618751.png

 

 

When expanding to warehouses, some rows cause the visual to scroll up and away from the expanded row. When this happens the visual will error if the row is collapsed again. Giving error "DAX comparison operations do not support comparing values of type Text with values of type True/Fales. Consider using the VALUE or FORMAT function to convert one of the values."

TayTay_1-1723781618953.png

 

Applying then clearing any filter fixes the issue and the visual will load.

 

Here is a video showing the behaviour.

Status: Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎08-18-2024 06:54 PM

Hi @TayTay 

The problem should be in your filter conditions. If without any DAX applied. You need to check if your filter conditions are comparing or filtering fields of different data types, causing the error to be reported. Also you mentioned two custom columns, how is this custom column set up?

 

Best Regards,
Community Support Team _ Ailsa Tao

TayTay
Frequent Visitor
‎08-18-2024 07:24 PM

Hi @Anonymous 
There are no filters applied to the visual and the only columns that aren’t text are Month and Quantity. I show there are no filters on the visual at 0:02 of the video.


The two custom columns are created in query using M. Some items are 2 packs so for easier comparison I've converted them into eaches.

 

Custom Quantity column is:
#"Added Quantity" = Table.AddColumn(Source, "Quantity", each if [Base Unit] = "Double"
then [Base Quantity] * 2
else [Base Quantity]),

 

Custom Unit column is:
#"Added Unit" = Table.AddColumn(#"Added Quantity", "Unit", each if [Base Unit] = "Double"
then "ea"
else [Base Unit]),

 

Idea Statuses