Forum Discussion

PedroMorbey's avatar
PedroMorbey
Frequent Visitor
2 years ago
Solved

Native Matrix Visual Glitch - Expand/Collapse buttons not working

Hello,   I currently have a DAX measure that's triggering quite the weird behaviour on the native Matrix visual. I'm using 4 fields which belong to the same table (Dim_Product) on the Rows and tha...
Need Help
  • PedroMorbey's avatar
    PedroMorbey
    2 years ago

    Anonymous ,

     

    Indeed, after trying to simplify/alter it to see some changes, I was able to arrive at the normal Matrix visual behaviour. I changed the intermediate virtual tables FILTER calculation from a nested IF to a regular boolean evaluation and it worked!

     

    I went from this initial approach where the FILTER condition of the intermediate tables had some nested IFs:

    // Filter tables
    VAR _Filter_HighHigh =
        FILTER(    
            _Final_Table,
            IF(
                "High x High" IN VALUES(AUX_9Box_Cluster_Performance_Slicer[Performance Cluster]),
                IF( _Threshold_Type = "Absolute",
                    _Net_Sales_Absolute_High_Threshold < [@Net Sales] && _Gross_Margin_High_Threshold < [@Gross Margin],
                    [@CumulatedPct] < _Net_Sales_Relative_High_Threshold  && _Gross_Margin_High_Threshold < [@Gross Margin]
                    ),
                False
                )
            )

     

    To this simpler one:

     

    // Filter tables
    VAR _Filter_HighHigh_Abs =
        FILTER(    
            _Final_Table,
            "High x High" IN _Selected_9Box_Clusters
            && _Threshold_Is_Absolute
            && _Net_Sales_Absolute_High_Threshold < [@Net Sales] && _Gross_Margin_High_Threshold < [@Gross Margin]
            )

     

     

    This measure is far from being optimized, but for now it is working as intended without any major performance issues. Thank you for getting back to me.

     

    Best regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PedroMorbey ,

Based on the information you have provided, the expand/collapse functionality of a matrix visual object may be affected by the data model and the DAX metrics applied to it. There are several steps you can take to troubleshoot and resolve the issue:

  1. Try simplifying the metric to see if the problem still exists. This helps determine if the complexity of the metric is indeed the root cause. You can start by breaking the metric down into smaller, simpler parts and testing the expand/collapse functionality of each part.
  2. Ensure that the relationships between tables are correctly defined. Incorrect or inactive relationships may lead to unexpected behaviour of visual objects. For more details see:
    Relationship troubleshooting guidance - Power BI | Microsoft Learn
  3. Try creating a simple explicit metric (e.g., sum of sales) and see if the expand/collapse function works as expected. This helps isolate the problem from the specific DAX metric you created. For more information on explicit and implicit metrics, see:
    Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.