Forum Discussion

Ashok_Gopeani's avatar
Ashok_Gopeani
Helper I
2 years ago
Solved

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 d...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

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