Forum Discussion
mohittimpus
Helper V
Helper VHow to get Percentage Difference value in Bar Chart
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
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)
2 Replies
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)
mohittimpusThank you Anonymous It is working fine and I got my Required output.