Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

combine two column charts

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 ho...
Need Help
saurabhkudale96's avatar
saurabhkudale96
Frequent Visitor
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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.