Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
AVS218
Frequent Visitor

Line Chart visualization based on Avg. Price per year and duration of contract

‎07-14-2021 08:32 AM

Hi All,

 

End Solution Expected: I want to show Avg Price on Line chart for each project based on duration of contract2021-07-14 16_29_05-Presentation1 - PowerPoint.png

 

 

 

 

 

 

 

 

 

Fields I have as per below sample table

Project NameAvg. Price per YearTotal Contract Year

Project a

£ 2000020
Project b£ 3000015
Project c£ 4500025
Project d£ 6500020
Project e£ 2500012
Project n£ 3500015

 

Any idea how to achieve above graphical representation based on these three fields

Message 1 of 6
811 Views
0
1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

‎07-25-2021 11:25 PM

Hi @AVS218 ,

 

Based on the sample data you provided, 

please see the attached file.

 

The result is based on the expected output you provided.

2021_07_26_10_24_59_yearly_contract_Power_BI_Desktop.png

 

Hope this idea helps.

View solution in original post

yearly contract.pbix
Message 4 of 6
560 Views
5 REPLIES 5
mussaenda
Super User
Super User

‎07-25-2021 11:25 PM

Hi @AVS218 ,

 

Based on the sample data you provided, 

please see the attached file.

 

The result is based on the expected output you provided.

2021_07_26_10_24_59_yearly_contract_Power_BI_Desktop.png

 

Hope this idea helps.

yearly contract.pbix
Message 4 of 6
561 Views
AVS218
Frequent Visitor
In response to mussaenda

‎07-30-2021 07:58 AM

@mussaenda 

Thanks a lot... It helped us to solve major challenge we had and kill alternative approach used which was very time consuming. Post implementation of that solution, we came across a scenario where we have some projects with values split by year and some consolidated ... See example below. Is it possible to generate same visualisation when you have some projects captured as one line and some in multiple lines with unique line value

 

Visualisation we are trying to achieve is one by contract start year and one based on solution you already provided

Project NameContract Start DateContract End DateContract Term (Years)Avg. Price per year
Project A31/03/202131/03/2026540000
Project B25/11/202124/11/2026542000
Project C25/04/202324/04/20242050000
Project C24/04/202424/04/20252051000
Project C24/04/202524/04/20262060000
Project C24/04/202624/04/20272060000
Project C24/04/202724/04/20282060000
Project C24/04/202824/04/20292060000
Project C24/04/202924/04/20302060000
Project C24/04/203024/04/20312060000
Project C24/04/203124/04/20322060000
Project C24/04/203224/04/20332060000
Project C24/04/203324/04/20342065000
Project C24/04/203424/04/20352065000
Project C24/04/203524/04/20362065000
Project C24/04/203624/04/20372065000
Project C24/04/203724/04/20382065000
Project C24/04/203824/04/20392066000
Project C24/04/203924/04/20402066000
Project C24/04/204024/04/20412067000
Project C24/04/204124/04/20422067000
Project C24/04/204224/04/20432067000
Project D31/03/202131/03/2026553000
Project E01/12/202101/12/20222075000
Project E01/12/202201/12/20232075000
Project E02/12/202101/12/20242075000
Project E01/12/202401/12/20252075000
Project E03/12/202101/12/20262075000
Project E01/12/202601/12/20272075000
Project E04/12/202101/12/20282075000
Project E01/12/202801/12/20292075000
Project E05/12/202101/12/20302075000
Project E01/12/203001/12/20312075000
Project E06/12/202101/12/20322075000
Project E01/12/203201/12/20332075000
Project E07/12/202101/12/20342075000
Project E01/12/203401/12/20352075000
Project E08/12/202101/12/20362075000
Project E01/12/203601/12/20372075000
Project E09/12/202101/12/20382075000
Project E01/12/203801/12/20392075000
Project E10/12/202101/12/20402075000
Project E01/12/204001/12/20412075000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Project F01/12/202101/12/20412059000
Message 6 of 6
505 Views
0
AVS218
Frequent Visitor
In response to mussaenda

‎07-26-2021 09:37 AM

Super thanks for the solution. Really Appreciate it. It helped sort out main issue and gave us endless possibility

Message 5 of 6
544 Views
0
lbendlin
Super User
Super User

‎07-24-2021 02:18 PM

Your sample data is missing the date/year column.

Message 2 of 6
661 Views
0
AVS218
Frequent Visitor
In response to lbendlin

‎07-24-2021 10:25 PM

Apologies I missed on that... Data will look like below and I have to consider Contract Start Date as Year 1 and then build on that based on Total Contract Duration. i.e. for Project A Contract Start Year as per date is 2019 and duration is 20 years. so my line chart should display £20k price from 2019 to 2039 and so on for other projects. 

 

Eventually we would like to visualize in two ways one displayed in my previous message and one which will show how much all projects cumulatively earn revenue in a specific year e.g. 2025

 

Project Name

Avg. Price per YearContract Start DateTotal Contract Duration

Project a

£ 2000020/07/201920
Project b£ 3000020/01/202015
Project c£ 4500020/05/202025
Project d£ 6500025/10/202020
Project e£ 2500024/02/202112
Project n£ 3500022/05/202115
Message 3 of 6
635 Views
0

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All