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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
abhishekpati86
Helper III
Helper III

Display of text is not in proper sequence.

Hi All,

 

I have the below text that I want to show in the introduction page of my report. The text is a imported from an excel sheet to the Power BI as a text column.

 

EXCEL VIEW

 

Capture.JPG

 

POWER BI TABLE VIEW

 

Capture.JPG

When I try to show it in a table or matrix, it shows the below sequence of text that is completely out of sync. Can anyone please help me to get the same sequence of text as it is in my original file ? ( I had also tried the Longtext Viewer custom visual from Power BI and the result is the same.)

 

MATRIX Visualization 

 

Capture.JPG

 

TABLE Visualization

 

Capture.JPG

1 ACCEPTED SOLUTION

@abhishekpati86

 

Change index to numeric value (Modeling - Data Type) and should be work




Lima - Peru

View solution in original post

3 REPLIES 3
CheenuSing
Community Champion
Community Champion

@abhishekpati86

 

Try this out.

 

1. Go to the edit queries tab.

2. Go to Add Column tab under that

3. Click on Add Index Column

4. From the rop down select Start from 1

5. With this each row your source gets indexed

6. Save

7. In the Modelling tab , choose the table and choose the description column and set the sort by column to Index column added earlier at step 3 above.

 

If this solves your issue please aaccepth this as a solution and also give KUDOS.

 

Cheers

 

CheenuSing 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Hi @CheenuSing,

 

I have updated the below table with the Index column.

 

Capture.JPG

 

When I sort the Introduction column with the Index column, still the below text on the Power BI is not in sync.

 

Capture.JPG

@abhishekpati86

 

Change index to numeric value (Modeling - Data Type) and should be work




Lima - Peru

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.