Re: Show historical evolution in line chart after ...

Martin-Prague · ‎05-09-2018

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

v-piga-msft · ‎05-14-2018

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 · ‎05-14-2018

@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,.....

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