Forum Discussion

Jaykumar31's avatar
Jaykumar31
Frequent Visitor
1 year ago
Solved

Customize the Matrix visual in Power BI

Hello, I have data in the tabular format shown below in fig(A). There are n number of customers using different products. Customers are raising investigation work items, which are represented as num...
Need Help
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi Jaykumar31,
    Thank you for follow up.     

    I have reproduced your scenario based on the details provided, and I'm able to get the expected output as per your requirements. Specifically: 

    • The dynamic column headers (Customer Groups) are now truncated to a fixed character length when they exceed the limit. 
    • The matrix visual layout remains consistent even if new, longer values appear in the data. 
    ShortCustomerGroup =  

IF( 

    LEN([CustomerGroup]) > 15, 

    LEFT([CustomerGroup], 12) & "...", 

    [CustomerGroup] 

)

     

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you. 

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Jaykumar31,

Thank you for reaching out to the Microsoft Fabric Forum Community.


Check the solution provided by danextian,fahadqadir3. It outlines the approach for achieving dynamic grouping and highlights key limitations around calculated columns. 

Please refer to the document link below for a better understanding: 

Using calculated columns in Power BI Desktop - Power BI | Microsoft Learn 

To better assist you, could you please share a small sample of your actual data in tabular format? That will help us provide information.

 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

 

Thank you.