Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Stacked and Line Columns Chart


I have a bar and line chart, on two levels, per month and days, the first thing you see are the months and with the drilldown low to see it for days,the lines are participation and monthly growth, so when I go down to the days do not show me the lines.

I was thinking of putting the condition to a measure that when I'm standing in days I don't do any calculations.

New Member

Good morning esteemed community,

I need to make a specialized Gantt chart, but not having it available in visuals, I decided to do it with the option of stacked bars (In Excel I have made this chart), the point is that I need to include 2 different series (In one project projection (with several fields) and the other series would be the baseline)

Then I give you a screenshot of the chart that in Excel and how I go so far in PBI,

In Power BI I need:

Option 1: Make the gray bar thicker (approx. twice) behind the blue bars or that each gray bar

Option 2: Or that each gray bar is glued to the blue bar above it

The other drawback I have is that to do in PBI I had to put the data in number format, however in the EJe X I need you to show me dates,

Thank you in advance for your valuable support

Anotación 2020-06-10 082039.pngAnotación 2020-06-10 082100.png

Community Support
Community Support

Hi @gisellemr4,


Could you share the sample pbix via cloud service like onedrive for business?So that we can better understand your scenario.


Best Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User IV
Super User IV

@gisellemr4 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors