Adjusting Matrix cell width

[Ashok_Gopeani]

Hi Team,

I have implemented matrix visual and displaying matrix visual based on selection on slicer selection... like below

but our end user required to display the data like below by default

could you please let me know how we can set the width in matrix column. thanks in advance.

please refer below file for pbix file

https://drive.google.com/file/d/1s5pCdoHw4PYweT4FDUkl34c3TTr_dh7s/view?usp=sharing

[PijushRoy · Accepted solution]

Hi @Ashok_Gopeani 

Please find the attached PBIX

I have updated two DAX (please find the bold section). UNICHAR(10) is used for line break.

CountryState = CONCATENATE('Country State'[Country]& "-" &UNICHAR(10), 'Country State'[State])

CounStDist = CONCATENATE('Country State'[CountryState]& "-" &UNICHAR(10),'Country State'[District])

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin