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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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