Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
| 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êsThe Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |