Graph using multiple columns in X axis

Question

Dear Together,&nbsp;I got a requirement to create a graph to represent the project growth. I tried with some measures and tables. But couldnt get the desired output. So need your support.&nbsp;We have a table with project details as below.&nbsp;ProjectsStartEndProject107-2014&nbsp;Project210-201412-2015Project301-201612-2016Project405-2016&nbsp;Project502-201712-2018Project603-2018&nbsp;&nbsp;We need to create a graph like below.&nbsp;

amitchandak · Answer

rpn7kor&nbsp;,
refer my blog on the similar type of data can help ?
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

rpn7kor · Answer

Dear amitchandak ,&nbsp;Thanks for your guidance.&nbsp;I have tried as per your blog. Still i have one issue about total projects. i would like to show total project in incremental way like below.Year&nbsp;20142015201620172018Running22323Closed&nbsp;11&nbsp;1Total&nbsp;22456Is there any clue?

anonymous · Answer

Hi&nbsp;rpn7kor&nbsp;,Could you please provide the calculation logic of Running and Total? For example: Year 2018, why the number of running projects is 3, but the total number of projects is 6? How to calculate them?Best RegardsRena

rpn7kor · Answer

Hi Rene,&nbsp;Thanks for your message.&nbsp;Year&nbsp;20142015201620172018Running (Current year + previous years)&nbsp;22323Closed (which are completed)&nbsp;11&nbsp;1Total Projects (Current year + previous years)22456&nbsp;For example , 2018 has total of 6 projects (2 from 2014 + 2 from 2016 + 1 from 2017 + 1 from 2018)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and has 3 running projects (total project - closed projects)&nbsp;Thanks.

rpn7kor · Answer

No...:(

Forum Discussion

Graph using multiple columns in X axis

5 Replies

Related content

Sequential Order column based on multiple criteria

Multiple columns for map graph

Multiple line and clustered columns chart

Creating Cumulative Graphs

Summarize Multiple Columns

Projects	Start	End
Project1	07-2014
Project2	10-2014	12-2015
Project3	01-2016	12-2016
Project4	05-2016
Project5	02-2017	12-2018
Project6	03-2018