Comparing Actual vs Target Visually

[meiwah]

I would like to compare actual and budget figures visually, ideally in a tree. The visual should show a breakdown from the topmost level, to category, then sub category

I've used the xViz Hierarchy Tree. But it can only display either (1) actual, budget or (2) actual, variance (actual - budget), variance %. It can't display all values actual, budget, variance, variance % together. 

Attached is xViz Hierarchy Tree visual which I've used. It satisfy most of the requirements of my usecase but couldn't display all the values I want. 

Is there any other visual which can do the same? Pls advise. Thank you very much!

[v-csrikanth]

Hi @meiwah 
As mentioned your issue got resolved.If possible, kindly post your solution in this thread so the community can benefit from it. It would be helpful to others facing a similar situation.
Thanks again for your contribution!

Best Regards,

Cheri Srikanth

[meiwah · Accepted solution]

Thanks everyone! Actually, there is no solution for this. I displayed the data using a matrix instead

[v-csrikanth]

Hi @meiwah 

Hi 

Thank you for being part of the Microsoft Fabric Community.

As highlighted by @praveen_511 @Ritaf1983 @, the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolve.
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Best Regards,

Cheri Srikanth

[meiwah]

Thanks Cheri! I'm appreciative of the help rendered by @praveen_511 @Ritaf1983 but these don't address my requirements. My issue has not been resolved 😊

[praveen_511]

You need a visual that displays actual, budget, variance, and variance % together.
Alternatives include Power BI’s Decomposition Tree, hierarchical variance tables, and custom Power BI visuals.
Check Power BI AppSource for more advanced hierarchy visuals that suit your needs.
xViz Advanced Decomposition Tree might offer better flexibility than the standard version.
Explore these options and let me know if you need help configuring them!

[meiwah]

Thanks Praveen, xViz Hierarchy Tree is the same as xViz Advance Tree. I've contacted the support from xViz and the reply is this visual can't satisfy my usecase. I've already checked the Power BI Visual Gallery 

[Ritaf1983]

Hi @meiwah 
You can try to uuse a decompasition tree 
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree

https://www.youtube.com/watch?v=cH620qR1uQU

Or matrix with visual calculations for hierarchial calculations
https://www.youtube.com/watch?v=h4vF1UndHys

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

[meiwah]

Thanks Ritaf, I've tried the Decom Tree in Power BI Desktop but it can only show one value under analysis. May be I can only display it by a table or matrix