Forum Discussion

ipso's avatar
ipso
Frequent Visitor
4 years ago
Solved

HELP TO GRAPH multiple data

 

I very kindly request information, for the following inconvenience
HELP FOR GRAPHING MULTIPLE DATA IN ONE CEL

 

 

I have 

try to separate the columns by character / and it only brings me in the graph the first data found in the first column.

how could i graph this?

 

 

ty for your help

 

  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Step by step...

    Select the column and, under the Home tab,  click on Split column -> by delimiter

    Type in the delimeter in the box, and in advanced options chooe split into rows.

     

    Finally select the column and under the Transform tab, select Format and Trim and then Clean.

     

     

15 Replies

  • Arul's avatar
    Arul
    Super User
    4 years ago

    ipso ,

    please provide clear info on your actual and expected output.

    • ipso's avatar
      ipso
      Frequent Visitor
      4 years ago

      HELLO. ty for your time...

      i have to do the analisys of that data and i have a problem...

       

      One of those cells have multiple data in one cell for example

       ID             DATA

        X             A / B / C / D

        Y             C / D

      I need know how many have each ID in ESPECIFIC data and get that in a table:

             A   B   C   D      TOTAL

      X      1   1  1    1         4

      Y                 1    1       2

                                        6

      I tried to do that with split column but the table just give me the first data found in the first column

           A   B  C  D  TOTAL

      X    1                   1

      Y              1         1

                                  2

       

      I managed to do the exercise by making a table by column, but I need the data in a single table like this:

       

             A   B   C   D      TOTAL

      X      1   1  1    1         4

      Y                 1    1       2

                                        6

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    In the Query Editor, split the second column by rows with / as a delimiter.  Now create your desired visual.

    • HenriqueReis's avatar
      HenriqueReis
      Resolver I
      4 years ago

      Hi!

       

      First open the query editor in here:

      So, you're going to have this:

       

      Right-click on the top of the column, then go to "split column" and "by delimiter":

       

      So, you gonna see this screen:

       

      The final result you gonna have:

       

      Return to Power BI with a left click here:

       

      Regards!
      https://www.youtube.com/channel/UC9nTjkTNOhnQxHj57tj45lw

        

      • ipso's avatar
        ipso
        Frequent Visitor
        4 years ago

        Hola, hablas español?

    • ipso's avatar
      ipso
      Frequent Visitor
      4 years ago

      THANKS FOR YOUR TIME.

       

      I have to do the analisys of that data and i have a problem...

       

      One of those cells have multiple data in one cell for example

       ID             DATA

        X             A / B / C / D

        Y             C / D

      I need know how many have each ID in ESPECIFIC data and get that in a table:

             A   B   C   D      TOTAL

      X      1   1  1    1         4

      Y                 1    1       2

                                        6

      I tried to do that with split column but the table just give me the first data found in the first column

           A   B  C  D  TOTAL

      X    1                   1

      Y              1         1

                                  2

       

      I managed to do the exercise by making a table by column, but I need the data in a single table like this:

       

             A   B   C   D      TOTAL

      X      1   1  1    1         4

      Y                 1    1       2

                                        6