cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Martin-Prague Regular Visitor
Regular Visitor

Show historical evolution in line chart after selection of period

Hello Experts,

 

I would like to allow to my users to select YEAR/ QUARTER and then in tiles show YTD values - currently works.

 

But as well as they are challanging me to show evolution for previous 5 quaters after the selection in the line chart. Where I have no clue at all. The interaction is really tricky in this case.

 

Please see the screenshot for desired results.

Is this possible?

I will really appreciate your help.

 

Kind regards,

Martin-Prague

 

Power BI question.PNG

4 REPLIES 4
Martin-Prague Regular Visitor
Regular Visitor

Re: Show historical evolution in line chart after selection of period

Good morning, anyone?
Community Support Team
Community Support Team

Re: Show historical evolution in line chart after selection of period

Hi @Martin-Prague


 I would like to allow to my users to select YEAR/ QUARTER and then in tiles show YTD values - currently works.

 

But as well as they are challanging me to show evolution for previous 5 quaters after the selection in the line chart. Where I have no clue at all. The interaction is really tricky in this case. 

 

 


 

What values about previous 5 quaters do you want to show? YTD or sum total?

 

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

For reference, here is a thread that similars to your case which calculate the previous 5 years values based on selection.

 

BestRegards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Martin-Prague Regular Visitor
Regular Visitor

Re: Show historical evolution in line chart after selection of period

@v-piga-msft

Hello,

 

my requiremet has littble bit evolved since the time.

 

I should be able to select e.g. Q2'18 with once slicer and show in 100% comparison between Q2'17 (Same period last year).

Same period last year should be shown as another column.

 

See the pircture.. this is for BELGIUM.  Same for France, Italy,.....

COmpare PBI - NEW.PNG

Do you have any idea?

It is similar to the link you shared, but should not be showing continuous previous periods but SAME PERIOD LAST YEAR in 100% COLUMN STACKED CHART SPLIT BY BRAND.

Important is that selection and same period last year is in 2 diffrent columns to be able to easily compare.

 

Kind regards,

Martin-Prague

 

 

 

 

 

Highlighted
Martin-Prague Regular Visitor
Regular Visitor

Re: Show historical evolution in line chart after selection of period