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. 

fahadqadir3's avatar
fahadqadir3
Solution Supplier
1 year ago

Hello Jaykumar31  Review the attached .pbix file and screenshot you need to transform your data. review the steps in power query, similary you need to create additional custom column to color each customer.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

 

  • Jaykumar31's avatar
    Jaykumar31
    Frequent Visitor
    1 year ago

    Hi fahadqadir3  - Thanks for the reply. You have split the customer column based on the customer numbers, but the actual customer names contain text values like 'PQR,' 'XYZ,' 'ABC,' etc. Therefore, I can't split using that logic. Additionally, the customer names are very lengthy, so how can I adjust the column width?