cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Different Periods in same Line Chart starting from the same point

Hi community,

 

I'm dealing with time intelligence functions and I'm facing a challenge when it comes to let the final user selecting 2 different time periods with the final result that should be visualized as a line chart having 2 lines, both starting ath the beginning of the chart.

 

The final result should be something like this:

Different periods.png

As you can see, even though the 2 periods have different lenghts (in terms of days) and starting dates, they are somehow aligned for the first 16 days, displaying the remaining 4 days just for the longer period (green).

 

That being said, I had some ideas related to parameters but I'm not sure if this is the right way to go.

 

Has anyone faced this kind of challenge?

 

I'm pretty curious because dealing with/visualizing different periods (lenght and starting day) is one of the most challenging topic I've faced working in the BI enviroment.

 

Thanks in advance.

 

 

Fabio

Follow me on Twitter:@PantoMvp
Get in contact on Linkedin: Fabio Fantoni
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Different Periods in same Line Chart starting from the same point

@Panto , you need to have a date table connected with your table and another disconnected date table. The first formula will consider period 1 which on date table. As it joined you Measure will work

 

Measure = Calculation<>....

 

The second period will come from the disconnected table Date1, we will not use this in join just move the date

new measure =
var _min = minx(allselected(Date),Date[Date])
var _min1 = minx(allselected(Date1),Date[Date])
var _diff = datediff(_min1,_min,Day) // You may have try datediff(_min,_min1,Day)

return
calculate([measure], dateadd(Date[Date],_diff,day))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: Different Periods in same Line Chart starting from the same point

@Panto , you need to have a date table connected with your table and another disconnected date table. The first formula will consider period 1 which on date table. As it joined you Measure will work

 

Measure = Calculation<>....

 

The second period will come from the disconnected table Date1, we will not use this in join just move the date

new measure =
var _min = minx(allselected(Date),Date[Date])
var _min1 = minx(allselected(Date1),Date[Date])
var _diff = datediff(_min1,_min,Day) // You may have try datediff(_min,_min1,Day)

return
calculate([measure], dateadd(Date[Date],_diff,day))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Community Support
Community Support

Re: Different Periods in same Line Chart starting from the same point

Hi ,  @Panto 
Not very clear.Maybe I need a bit more information.

Please explain this phrase in more detail:" even though the 2 periods have different lenghts (in terms of days) and starting dates, they are somehow aligned for the first 16 days"

It seems that the four parameters do not correspond to the picture you show?

 

You may check if the following pbix helps:

pbix attached

 

Best Regards,
Community Support Team _ Eason

 

 

Highlighted
Helper I
Helper I

Re: Different Periods in same Line Chart starting from the same point

Hi @amitchandak 

 

thanks for your quick feedback: that makes sense.

 

Propbably I was too focused on replicating the same logic used in another tool via parameters and didn't think about your idea which seems really what I'm looking for.

 

Have a nice day

 

Fabio

Follow me on Twitter:@PantoMvp
Get in contact on Linkedin: Fabio Fantoni

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors