Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help on Stacked Bar Chart

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  

 

 

Need Help
Tutorial Requests

3 Replies

  • itsme's avatar
    itsme
    Resolver I
    6 years ago

    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's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    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.