Forum Discussion
Clustered column chart for machine input and output..
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 TeamIf 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!
Hi Jaehir ,
I would like to acknowledge the valuable input provided by Sergii24 .
His initial ideas were instrumental in guiding my approach.
In my investigation, I took the following steps:
After the unpivot, creates a calculated column:
Type =
SWITCH(
TRUE(),
CONTAINSSTRING([Attribute], "(IN)"), "IN",
CONTAINSSTRING([Attribute], "(SCRAP)"), "SCRAP",
CONTAINSSTRING([Attribute], "(OUT)"), "OUT",
"Unknown"
)
Drag DATE to the X-axis, Value to the Y-axis, and the created calculated column to Legend.
If you do not want to show SCRAP, just filter it out in Filter.
The final page result is shown below:
The pbix file is attached.
If you have any other questions please feel free to contact me.
I would be grateful if you could provide me with sample data for testing, please remove any sensitive data in advance.
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!
The graph is exactly what i nearly wanted. Though on the x axis, is there any way that i can have for each grouped bar (IN and OUT), instead of having date, i can have the machine type. For example, the 29 Feb, 12AM replaced with Machine 1 and the corresponding bar would be the other machine type like Machine 2, Machine 3. I tried unpivoting the Machine 1 (IN) and Machine 1 (OUT) and rename the attribute into Machine 1, while the table is exactly what i wanted, when I unpivot Machine 2 (IN) and Machine 2 (OUT), the column Machine 1 became messy.
I imagine if the attribute (Machine 1), (Machine 2), (Machine 3), can be inserted onto x axis, the data will represent each of the other machine and the bar (Machine 1 Value), (Machine 2 Value), (Machine 3 Value), represent each IN and OUT values. Sorry if im wrong in this but thats how i imagine it.
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 TeamIf 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!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.
