Is it a bullet graph I want? Exact value AND the range of others.

[jeseng]

Hi there,

I have data for multiple areas in my city, Subarea no 1 to 36. They each have different variables for example; unemplowyment rate, percent of the population that smoke; percent of the population that are overweigth and serveral others. All the values are in percent %. My users will start by selecting ONE SUBAREA and all the values for that area will be presented in visuals. For some of thes variables I want to not only show the exact value for the selected subarea but also the RANGE of the others, what the lowest value is as well as the highest. I thought it might be a bullet graph that I need for this, but I dont seem to find any good ones to download... 

I want my visual to look something like the image to the right, not the left: 

 So the bar shows the value for the selected subarea (70%) but I can also se the range for the other areas; the lowest (50%) and the highest (90%). Is this at all possible?!

[lbendlin]

I hesitate to mention "Box and Whiskers" as that is more quartile centric.  But hey, there's always Deneb!

[jeseng]

Thank you for your response,

If I understand correctley the lipstick graph compares two measures? I think I need 3...? One for the accual value, one for the smallest and one for the highest?

[Ritaf1983]

You can play with areas:

Those graphs are not my cup of tea, I think you should try to play with it.

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

[Ritaf1983]

Hi @jeseng 
The closest to your description as I know is the "lipstick" graph.
Check this video by creating it with error bars :

https://www.youtube.com/watch?v=0VQzdMQRpbk

or the customized visuals:
https://visuals.novasilva.com/shop/pbi-visuals/lipstick-bar-chart-for-power-bi/

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