I need to display the month name with a total of 11 characters

[durgaraop21]

Could you please any one help me on this.

I need to display the month name with a total of 11 letters, filling the remaining space with blank spaces in the Matrix visual.

 

Screenshot:

Expected output:
WithOut manually dragging. 

 

[v-xingshen-msft]

Hi @durgaraop21 ,
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

[Bibiano_Geraldo]

Hi, @durgaraop21 
Add a new calculated column to your date table with the following DAX formula:

FormattedMonth = FORMAT('YourTable'[Date], "MMMM") & REPT(" ", 11 - LEN(FORMAT('YourTable'[Date], "MMMM")))

Replace the original month column in your Matrix visual with this new calculated column.
This formula formats the month name and appends the necessary number of spaces to make the total length 11 characters.

[rajendraongole1]

Hi @durgaraop21 - Create a New Column for the Padded Month Name: Use the DAX FORMAT function along with REPT to pad the month name to exactly 11 characters. Add this calculated column to your Date table or relevant table with month names.

Padded Month Name = FORMAT('DateTable_t'[Month], "MMMM") & REPT(" ", 11 - LEN(FORMAT('DateTable_t'[Month], "MMMM")))

[durgaraop21]

@rajendraongole1 Thanks for your reply....
This one is not working as expected.

Requirement:

When I drag this new column, the visual is not allocating the required space. The requirement is for it to take up 11 characters (including the month name and any remaining empty spaces) within the visual.