How to combine two histograms with different x-axis time fields into one stacked column chart ?

[TG-516]

One histogram report aggregated by incident created month-year, and another report aggregated by incident completed month-year, how can I put these two reports into one stacked column chart in PowerBi?

I want to create a visual like this:

Thank you for your help!

[Ritaf1983 · Accepted solution]

Hi @TG-516 
To get a stacked column with both statuses you need to calculate 2 measures :
1. For "created"

2. For "Closed"

and put these 2 measures on the Y-axis:

Link to my sample file with a similar scenario 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[TG-516]

Thank you! This helps a lot.

[Ritaf1983]

Happy to help 🙂