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 how I could do that? Thank you. 

 

 

Need Help

4 Replies

  • saurabhkudale96's avatar
    saurabhkudale96
    Frequent Visitor
    3 years ago

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

      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:

       

       

  • 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.