Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AVS218
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

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

5 REPLIES 5
mussaenda
Super User
Super User

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.

@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

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

lbendlin
Super User
Super User

Your sample data is missing the date/year column.

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors