Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
| Project Name | Start Project Date | End Project Date | Year | Project Duration |
A | Friday, June 10, 2016 | Monday, September 30, 2024 | 8 | 8 Year 3 mos |
| B | Friday, May 1, 2020 | Friday, June 30, 2023 | 3 | 3 Year 1 mos |
| C | Monday, March 22, 2021 | Friday, March 31, 2023 | 2 | 2 Year 0 mos |
| D | Wednesday, January 6, 2016 | Friday, June 30, 2023 | 7 | 7 Year 5 mos |
| E | Sunday, February 1, 2015 | Friday, October 31, 2025 | 10 | 10 Year 8 mos |
I want a output Like Below Visual But in X-axis i want to see only Years and data lable show the project Duration same like below visual. only Change in X-Axis I want to see the years.
I want outpul like below Image
Hi @Girish_123 ,
Don't know how you have the information and the data to give the result above but taking the data you send out I created a column with the duration in year has a decimal.
Duration Total = DATEDIFF('Table'[Start Project Date ], 'Table'[End Project Date ], MONTH) / 12
When I place this on the chart the X-axis got the values:
The axis by default adjust to the size of the data and of the visualization and that is why you don't get all the numbers but it's a similar visualization.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português