Forum Discussion
Can someone help me with the below visual?
I need to get a visual where I can compare PLAN values with Log + Remaining Plan Values.
The Plan Bar compared with Logged + Remaining Plan --> where Logged needs to be color 1 and Remaining Plan needs to be Color 2.
Your Help is appreciated.
3 Replies
Refer to this post on how to achieve different colors in a single bar..
https://community.powerbi.com/t5/Desktop/Color-formatting-of-every-bar/m-p/844210#M405378
If it helps, mark it as a solution
Kudos are nice too
I have two separate Bars.
Hi JaydipPatel81,
Creating a clustered column chart with one of the columns being stacked is perhaps not the correct visual choice here. Showing bars in this way is less intuitive to perceive visually and takes longer to process cognitively for your viewers than, say a Bullet Chart.
There's a few bullet chart visuals in the marketplace, and I use them a lot for similar use cases as yours.
I've listed in my personal order of preference, but see how you get on with them:
- Bullet Chart by OKViz
- Bullet Chart - xViz
- Bullet Chart (Microsoft)
Not exactly the answer you were hoping for, but it's generally regarded as the most effective way to handle this particular visualisation challenge.
Good luck!
Daniel
If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂
