Forum Discussion
Stacked Bullet Chart
I need to make something like the above chart. My use case is a reforecast (in blue) and paid/committed/pipeline in green. Another use case could be a target sales with actuals from products x/y/z. I have tried various custom visuals, but none have the stacking. I've considered creating a DAX formula for the total forecast less the sum of the three stacks and then just using a stacked bar, but that's really not what I want. Any ideas would be most helpful. This is a POC, so I am able to make any data transformation necessary. Sample data is attached. Thank you!
https://kauffman.box.com/s/w2xffiwt2cgqr983vnlk5mdvfesc8udy
@budget @stackedbar @bullet
Hello Anonymous Thank you for your reply! Unfortunately, that visual will not work as I have more than 3 states (paid, committed, pipeline, and reforecast).
What I ended up doing was two stacked charts that were nearly on top of each other but the back (reforecast) was aligned left but a bit higher y coordinate.
The front stacked bar needed the detail stacks (measures) plus a new measure (with the same color as the back bar) that is for "remaining available."
The back stack bar was for the reforecast plus a new measure for "excess" in case the actuals were greater than the reforecast. (These new measures "available" and "excess" were necessary so that both stacked bars would have the same scale.) The excess color was set to white so it wouldn't be seen. The other tricks were to ensure the front had a transparent background and the back had any labeling in white (axes labels, title, etc) so they wouldn't be seen. Not the most elegant solution, but it works for what we need. Thank you for pointing me in the "lipstick" direction!
2 Replies
Hi dkernen2 ,
I suggest you to Stack within Lipstick Column chart from AppSource.
For reference: https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous Thank you for your reply! Unfortunately, that visual will not work as I have more than 3 states (paid, committed, pipeline, and reforecast).
What I ended up doing was two stacked charts that were nearly on top of each other but the back (reforecast) was aligned left but a bit higher y coordinate.
The front stacked bar needed the detail stacks (measures) plus a new measure (with the same color as the back bar) that is for "remaining available."
The back stack bar was for the reforecast plus a new measure for "excess" in case the actuals were greater than the reforecast. (These new measures "available" and "excess" were necessary so that both stacked bars would have the same scale.) The excess color was set to white so it wouldn't be seen. The other tricks were to ensure the front had a transparent background and the back had any labeling in white (axes labels, title, etc) so they wouldn't be seen. Not the most elegant solution, but it works for what we need. Thank you for pointing me in the "lipstick" direction!
