Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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
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
Thank you! This helps a lot.
Happy to help 🙂