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!

Anonymous's avatar
Anonymous
Not applicable
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!

Jaehir's avatar
Jaehir
Frequent Visitor
2 years ago

This is great! First one is exactly the visual i was looking for. Thanks a lot to everyone for helping me out. Now i can move forward on creating my company's desired dashboard.