Help on Stacked Bar Chart

[Anonymous]

Hi ,

i am stuck in stacked bar chart. i need to build chart Y-axis present Start to end data for each task as per the below table and below chart. any help on this request  

[mwegener]

Hi @Anonymous ,

has your question been answered?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[itsme]

Try creating a column or measure that finds the difference between EndDate and StartDate. You can use the DAX below as a template for a custom column:

TimeDiff = 'table'[EndDate] - 'table'[StartDate]

Now change the data type to Decimal Number. This will give you the time between the start and end date values in UNIX. If you are using the stacked bar chart, put the new metric (TimeDiff) in the Value section of the visual, put the Task column into the Legend section if you want it to look like the image you provided, or put it into the Axis section if you want the tasks listed on the y-axis.

I hope this helps!

[mwegener]

Hi @Anonymous ,

look at this.

https://appsource.microsoft.com/en-us/marketplace/apps?page=1&src=office&search=gantt&product=power-bi-visuals

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.