Forum Discussion
Customize the Matrix visual in Power BI
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.
Thanks for your reply. Could you please update your file to show how I can fix the column size? In my report, the columns change dynamically and sometimes contain more than 30-50 words. I want to set a fixed size for each column, and if the text exceeds, let's say, 10–15 characters, it should be truncated with '...' at the end.
I used the REPT function to fix the character length in a column, but it did not work out.
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.