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
Anonymous
Not applicable

Error displaying text in proper sequence in matrix

Hello, I am having problems dispalying text in the proper sequence. My expected result is to combine the 2 tables below in a matrix. 

yoong_00_0-1604541276286.png

However, its currently displaying the comments in a single line and the repeating it for the other 11 lines. Another one, is displaying wrong values but with proper comment sequence.

yoong_00_1-1604541437013.png

 

yoong_00_2-1604541606750.png

Is it the dax or relationship that is causing the problem? My pbix is attached below for reference. Thanks.
https://drive.google.com/file/d/1QRFQt3rU0BcVX011kbNww6vWRnqsvn7J/view?usp=sharing

 

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

@Anonymous ,

 

I do not see any relationship between them, that's the problem.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hello, I am having problems display my text in the proper order. The text is displayed in a single line and repeatedfor every line as below. 

yoong_00_0-1604540129947.png

What I wanted is to combine this 2 tables in a matrix.

yoong_00_1-1604540179514.png

is it my DAX measures or relationship that is causing the problem ? My pbix file is attached as reference.

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

@Anonymous,

 

This is the message I get upon clicking the link to the pbix file:

 

Sorry, the file you have requested does not exist.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

@DataInsights i tried to delete this question. My question has been asnwered in another post. Thanks

Anonymous
Not applicable

btw @camargos88 is there a way to show my actual values currently all the options display wrong values.

yoong_00_0-1604548379408.png

yoong_00_1-1604548436721.png

 

 

camargos88
Community Champion
Community Champion

@Anonymous ,

 

I do not see any relationship between them, that's the problem.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Anonymous
Not applicable

@camargos88 thanks solved it looks like I accidentally deleted the relationship. 

 

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.