Forum Discussion

TayTay's avatar
TayTay
Frequent Visitor
2 years ago

Matrix Errors When Collapsing Column

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.

Can anyone tell me what is causing this to happen?

 

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.

 

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

 

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

 

Here is a video showing the behaviour.