Forum Discussion

georgepaph12's avatar
georgepaph12
Frequent Visitor
3 years ago

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?

Need Help

4 Replies

  • georgepaph12's avatar
    georgepaph12
    Frequent Visitor
    3 years ago

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

      • georgepaph12's avatar
        georgepaph12
        Frequent Visitor
        3 years ago

        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.