Forum Discussion

Jaehir's avatar
Jaehir
Frequent Visitor
2 years ago
Solved

Clustered column chart for machine input and output..

Hello,   I am very new to power bi and my superior insist on me learning on how to use this without prior training. So I really appreciate with all the help I can get.   I have a set of table whi...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Jaehir ,

     

    Thanks for the reply from johnbasha33 .

     

    See which one you like?

     

    Or:

     

    The first visual object requires the creation of a calculated column:

     

    Machine = 
SWITCH(
    TRUE(),
    CONTAINSSTRING([Attribute], "Machine 1"), "Machine 1",
    CONTAINSSTRING([Attribute], "Machine 2"), "Machine 2",
    CONTAINSSTRING([Attribute], "Machine 3"), "Machine 3",
    "Unknown"
)

     

     

    Then:

     

    The second visual object needs to be like this:

     

    The pbix file is attached.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
2 years ago

From what I see at your screenshot the date should be okay: you already have all dates in the same column. When unpivoting columns, for unselected columns values will repeat, so if you 1 row with a single date for 3 machines and their values, the unpivoted version will have 3 rows (by number of machines), where the same date will be repeated.

What I suggested (unpivot machines) is just an example. Play around with unpivoting to obtain the desired result. Remember that to use any value in a legend they all should be within the same single column.   

Jaehir's avatar
Jaehir
Frequent Visitor
2 years ago

Hi so far ive tried using unpivot and it works well. The date followed through correctly for each IN and OUT. But i have an issue, when i unpivot the second sets of column, Machine 2 (IN),..Machine 2 (OUT), the table becomes a lot messier with too much duplication. I tried research online but whatever i tried like creating copied queries and merged queries, or unpivot both sets of column and then split column with delimeter, doesnt seems to succeed.