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

Stacked bar chart with date value

Dear Power BI community,


I am currently working on a graph that shows the status of various projects. The basic idea is the show the data on the x axis, and horizontal bars representing the timespan of the project on the y-axis.


Since it is not possible to use the date as a value, I had to use a workaround. The workaround consists of using a a stacked bar chart and converted date columns, using the days of the year instead of the date values. I added a vertical line representing 'today'. The stacked bars consist of a component that is the days of the year that the project hasn't started (component is in the color white so that it is not visible), another component that is progression in the project (measured as the percentage of progression * (end day-beginning day)), and a final component that is the amount of work that still has to be done ((end day-beginning day-progression in the project).


This results in the stacked bar chart depicted below:




There are two problems with this approach.


1) One of the requirements is that I show the date on the x-axis. Now it shows the days of the year. Would it somehow be possible to convert the 'days of year' to a date value in the labels?

2) One of the requirements is that the bar should have conditional formatting; the light blue portion should be green of the current progress is satisfactory and red if the progress is not considered satisfactory (whether the progress is satisfactory is deteremined by a text value in another column).


I am afraid that I might need to use a different approach than using the stacked bar chart. Suggestions on how to create a graph that meets my requirements would be really welcome.


Thanks in advance for your help. 


Kind regards,



Community Support Team
Community Support Team

Re: Stacked bar chart with date value

Hi MWN1990,


Based on your description, you can add days to 1/1 of that year. Firstly you should format your column like yyyy/01/01, then you can use function like dateadd(table[columns], days_number, day) to convert the days to a date value.


In addtion, to conditionally format the value in stacked bar chart, drag the column to Color saturation in Fields pane, then click Format pane-> Data colors, you can set minimun value and maximun value here:




Jimmy Tao

Helpful resources

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 135 members 1,720 guests