How to get Percentage Difference value in Bar Chart

[mohittimpus]

 I have one Bar chart Visualization and I need percentage Difference value from the previous value.

For Example below Image:

 

For example = 

To get Percentage Formula is = (current value - previous value)/ previous value

(210-120)/120 = 90/120 = 3/4 = 75% 

Below I am sharing .pbix file: 

https://drive.google.com/open?id=1CBP0kt7eUoJqbVM-CR9xXQgapgsbE0vz

[Anonymous · Accepted solution]

@mohittimpus Please create below measure to get percentage change

Measure = 
VAR _currValue = MAX('Sample'[Value])
VAR _preValue = CALCULATE(MAX('Sample'[Value]),'Sample'[Value]<_currValue)
VAR _prevData =  CALCULATE(SUM('Sample'[Data]),'Sample'[Value]=_preValue)
VAR _currData = SUM('Sample'[Data])
RETURN DIVIDE((_currData-_prevData),_prevData,0)

[mohittimpus]

Thank you @Anonymous  It is working fine and I got my Required output.