Forum Discussion
Adjusting Matrix cell width
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
Hi Ashok_Gopeani
Please find the attached PBIXI 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
1 Reply
Hi Ashok_Gopeani
Please find the attached PBIXI 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