Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
Did you build on the example in this post or did you use another means?
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.
Thank you! I am going to try and implement this today. I really appreciate your response!
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.
Thank u! It helped a lot!
Did you end up getting a visual close to your original post?
Yes! Here is an example
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |