cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BB90
Regular Visitor

Multiple years - Start at the same point on x axis

Hi,

 

We have some data on certain products and these products have a year of account associated with them, which is the year the product was offered. We can receive values relating to these products during the year and also after the year of account is finished but not prior to the year starting.

 

We have a requirement to show the development of different years of account on a line graph, with the lines starting at the same point on the x axis for all the years selected.

 

We have put together an example pbix file with dummy data to show how far we have got:

https://www.dropbox.com/s/fmwoxg13iw30ek8/Multiple%20years%20-%20Start%20at%20the%20same%20point%20o...

 

As you can see with the first graph, if we use the standard Date table we get lines starting at the first period of each year. We have tried creating some “Rolling Accounting Period” columns which we have used for similar requirements in our SSAS Cubes.

 

The graph on the right is close to what we need however, we do not want the lines to continue past the latest period we have data for.

 

We have tried a few different variations of the idea put forward in this video but had no luck:

https://www.youtube.com/watch?v=VXd1wl-5vKI

 

Is it possible to produce a graph like the second one but where the lines only go as far as the latest data available for that year of account?

 

Here are the measures from the file:

 

Measure Value = SUM('Fact'[Value])

Continuous Value =

SUMX(

   FILTER(

           ALLSELECTED('Date'[Date]),

           'Date'[Date] <= MAX('Date'[Date])

   )

   ,[Measure Value]

   )

Rolling Value =

SUMX(

   FILTER(

           ALLSELECTED('Rolling Accounting Period'),

           'Rolling Accounting Period'[Rolling Accounting Month] <= MAX('Rolling Accounting Period'[Rolling Accounting Month])

   )

   ,[Measure Value]

   )

 

Many thanks

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @BB90 

I am not sure if I understood your question correctly, but please check the below.

 

Picture2.png

 

https://www.dropbox.com/s/yi4ngc9tzcrv9mm/Multiple%20years%20-%20Start%20at%20the%20same%20point%20o... 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

2 REPLIES 2
Jihwan_Kim
Community Champion
Community Champion

Hi, @BB90 

I am not sure if I understood your question correctly, but please check the below.

 

Picture2.png

 

https://www.dropbox.com/s/yi4ngc9tzcrv9mm/Multiple%20years%20-%20Start%20at%20the%20same%20point%20o... 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

Hi @Jihwan_Kim ,

 

That's perfect - thank you very much!

 

Many thanks

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors