combine two column charts

[Anonymous]

Hi,

I created these charts in PowerBi and I wanna combine them to one chart. For each month I would like to have 2 bars ( 1 with incoming instruments and 1 with completed instruments) Any idea how I could do that? Thank you. 

[saurabhkudale96]

Try creating 2 different measures. 
1. incoming = calculate(count(Instruments), Status = "Incoming")

2. completed = calculate(count(Instruments), Status = "Completed")

Also, create a month name column out of the date field you are using.
--> MonthName = FORMAT(Date_Table[Date_column],"MMMM")

Now use the Clustered Column Chart Visual from the Visualizations pane. Keep the 2 measures in the Y-Axis and MonthName in the X-Axis. You will then get an output according to your requirement.

[Anonymous]

Thank you again for the help!

In my data I don't have different statuses, all the cases that I have are finished so I cannot count on the status.

I count the number of cases that arrived based on the case ID and the arrived date. I do the same for the cases that have been completed, I count on the case ID and the completed date. That's how I created the two different graphs, but I cannot create a combination of them. Thank you. 

[saurabhkudale96]

Hello @Anonymous ,

Please use a Clustered Column Chart Visual from the Visualizations pane. You can enter 2 fields in the Y-axis to have 2 bars near to each other.

Please upvote if this suffice your requirement.

[Anonymous]

Thank you for the reply! I tried the clustered column chart but I see a very weird graph.

On y-axis I want to count the number of cases while on x-axis I want to have the months with incoming instruments and completed instruments. 

I see something like this: