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
georgepaph12
Frequent Visitor

Display sequence of text

Hi, I have a table with columns that containcs sequence of text, e.g Failed/Online, it can look like this:

Failed
Failed
Failed
Online

 

I want to display the sequence in a table in powerBI, however, the table displayes only the two distinct texts, the result look like this:

Failed
Online

 

Anyone knows how to fix this?

4 REPLIES 4
georgepaph12
Frequent Visitor

There are multiple columns, in this case are 35 columns that I want to display but I have the same issue with every column.

hi @georgepaph12 

then expand your sample data with expected result please

Hi FreemanZ,

 

I expand my sample data with 5 columns, 35 is a bit tough to put here.

FailedOnlineOnlineFailedOnline
FailedOnlineOnlineOnlineOnline
FailedFailedOnlineFailedFailed
OnlineFailedOnlineOnline

Online

 

The expected results would be just to display the sample data as it is.

FreemanZ
Super User
Super User

hi @georgepaph12 

just plot a table visual with the only mentioned column. Or?

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.