Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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êsUser | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |