The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
87 | |
84 | |
36 | |
35 | |
32 |
User | Count |
---|---|
96 | |
75 | |
67 | |
52 | |
52 |