Balance Movements visualisation

[ghdunn]

Hi 

I am trying to show current counts of a metric analysed by stage but also show movements from one stage to another.  Can anyone suggest an 'out of the box' approach?  This is the sort of thing I am after. The particular look and feel is not vital but the concept of showing how things have changed is the key.

Let me know if any ideas!

Ged

[v-yingjl]

Hi @ghdunn ,

Based on your description, still not certain what does the values in the circle represent and your expected output. Seems need more information about this issue for further discussion. You can consider sharing some sample data.

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Yingjie Li

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

[pranit828]

HI @ghdunn 

For these kind of visualizations my first choice is below chart marked as 1. The formatting pane gets the result but in different lines. which can be hierarchial.

[BA_Pete]

Hi @ghdunn ,

You could visualise this using a waterfall chart. You would use the standard values section as your stage totals, then use the breakdown section for the intra-section movements. Won't look as cool as your example, but it will show all the elements you require and it's an out-the-box visual.

Pete

[ghdunn]

@BA_Pete 

dohh!  i should have mentioned i had considered waterfall but wanted something closer to the picture

definitely one to fall back on though, thanks!