cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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:

 

Stacked_Bar_Chart.PNG

 

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,

 

Martijn

1 REPLY 1
Highlighted
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:

1.PNG 

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Users Online
Currently online: 6 members 969 guests
Please welcome our newest community members: