Forum Discussion
Solved
Comparing Actual vs Target Visually
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 Hierarch...
Thanks everyone! Actually, there is no solution for this. I displayed the data using a matrix instead
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
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