How to calculate the difference between the bars and to picture it in a chart?

[JuliaF]

Hi everyone,

I'm looking for an equivalent visual to display the difference between the bars with Product Number on the x-Axis

Product A      Product B     Product C

Thank you in advance!

Best Regards,

Julia

[v-angzheng-msft · Accepted solution]

Hi, @JuliaF 

You could create a Line and stacked column chart to do this.

To create a measure like this:

Measure = 
var _current=CALCULATE(
    SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[ProductID]=MAX('Table'[ProductID])))
var _pre=CALCULATE(
    SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[ProductID]=MAX('Table'[ProductID])-1))
var _percent=DIVIDE(_current-_pre,_pre)
return _percent

Sample:

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MOORE020]

Did you build on the example in this post or did you use another means?

[JuliaF · Accepted solution]

This was the original visual:

Product A      Product B      Product C

I used this measure to calculate the gaps: 

difference between the bars=

var _current = calculate(

    AVERAGE(Table[Value]); FILTER(ALL(Table);Table[Index_Product]=MAX(Table[Index_Product])))

var _prev = calculate(

    AVERAGE(Table[Value]); FILTER(ALL(Table);Table[Index_Product]=MAX(Table[Index_Product])-1))

var difference_in_percent = DIVIDE(_current-_prev;_prev)

return difference_in_percent 

Then I used this visual  to display the gaps calculated with the measure mentioned above. The arrow was imported as a picture-file and grouped with the visual.

I hope this works out for you.

[MOORE020]

Thank you!  I am going to try and implement this today.  I really appreciate your response!

[v-angzheng-msft · Accepted solution]

Hi, @JuliaF 

You could create a Line and stacked column chart to do this.

To create a measure like this:

Measure = 
var _current=CALCULATE(
    SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[ProductID]=MAX('Table'[ProductID])))
var _pre=CALCULATE(
    SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[ProductID]=MAX('Table'[ProductID])-1))
var _percent=DIVIDE(_current-_pre,_pre)
return _percent

Sample:

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JuliaF]

Thank u! It helped a lot!

[MOORE020]

Did you end up getting a visual close to your original post?

[JuliaF]

Yes! Here is an example