Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Data processing, all values in one column

Hello, this is my first question. I'm new with PowerBI, I'm still learning.  Going straight into my problem: I have a database where all the data introduced by the worker is saved into one column ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello, thanks for your response, but I had already tried it, and I just tried it again and it's not working. Columns aren't being generated correctly, and it's seems like too many data is created. Any way I could use relations to make this work?

    • audreygerred's avatar
      audreygerred
      Super User
      2 years ago

      Can you share an example or your data by uploading the pbix?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        I had to change data because of company policy.

        Basically, there are two days in the date column, and each day there are several job_names, that are different job reports. Each job_name has several step_names, and each step_name has several field_values, but also, some field_values are in different step_names. 

        asically the structure of our report is 

        Job

             -Step

                  +field 1

                  +field 2

             -Step

                  +field 3

                  +field 1

         

        https://drive.google.com/file/d/1psuJIU5vp9PZLKRq5r7NvZ4bhXi-TtWa/view?usp=drive_link

         

        So I want to ideally transform each job_name into one row, with columns for each field_value, but having the same field name in different step names can dificult this. So I wondered if you could assimilate this using relations, so that when I segment any visual into the day (that is introuced as a field in Field_value,and therefore doesn't appear in every row), basically creating a relation between a Job_name and a day