Price % change over dynamic starting period

[Cristina101083]

I have a bar chart which is giving me the trend of pricing for a specific period which I am manipulating with a slicer.

What I need is the variance month over month vs. that first bar displayed.

Example:

January 1250

February 1300

March 1500

April 1200

May 1500

June 1150

January is always my fixed concept

So, I want to chart 

February 4%

March 20%

April -4%

May 20%

June -8%

How can I do this calculation?

Keep in mind that if the month in the chart is changed based on the slicer, it needs to recalculate that beginning value.

[v-huizhn-msft]

Hi @Cristina101083,

I try to reproduce using your sample data table.

Percentage = ( MAX(Table3[value])-CALCULATE(MAX(Table3[value]),Table3[Month]="Jan"))/CALCULATE(MAX(Table3[value]),Table3[Month]="Jan")

Then create a slicer, and a table visual to display the result.

If you have other issues, please feel free to ask.

Best Regards,

Angelia

[Cristina101083]

Angelia, 

Thanks for your reply, unfortunately I need the month to be dynamic based on the slicer selection. 

I was able to do a similar formula which is:

January Price=calculate([PipeLogixPrice],filter(all('Calendar'[Date]),and('Calendar'[Date]>=date(2016,1,1),'Calendar'[Date]<=date(2016,1,31))))

This formula gives me the January Price. Then I divide each month's value vs. that January Price.

Unfortunately, what I really need, is that January Price(which is now static) needs to be dynamic based on the selection of the slicer.

Thanks!

[v-huizhn-msft]

Hi @Cristina101083,

Please create a measure to get the selected date in slicer.

selected=CALCULATE(MAX(Table[Date]).ALLSELECTED(Table))

Then use the measure in your formula.

Best Regards,
Angelia