Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Ashok_Gopeani
Helper I
Helper I

Adjusting Matrix cell width

Hi Team,

 

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

Ashok_Gopeani_0-1708769578287.png

 

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

Ashok_Gopeani_1-1708769728459.png

 

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

 

 

 

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

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])

 

PijushRoy_0-1708778353317.png

 


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

View solution in original post

1 REPLY 1
PijushRoy
Super User
Super User

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])

 

PijushRoy_0-1708778353317.png

 


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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.