Visualisation Help!

[Anonymous]

Okay.

I have is four percentiles i've calculated in DAX, which tell you top, middle and bottom values of an overall dataset. In simple terms, these values represent good, average, bad and very bad results. 

Then, I have a ratio which is calulated at an individual level - so you can use a slicer to click on a person's name, and you will see their result compared to the four percentiles.

What I want is a visual which quickly and effectively demonstrates the individual ratio compared to the percentiles. 

Attached image is what i'm getting at, I know I won't get this out of Power BI but if you can think of any way I can represent something similar I would be grateful.

I have a cross filter against the individual ratio, so unless the name slicer is selected, the value is invisible. 

[ibarrau · Accepted solution]

Hi, there are some custom visuals that might be able to help with this. You will have to try them. If you just want a card that will change its color you have "Advanced Card" or "CardWithStates". If you want the four colors painted all the time and something like the arrow showing where you are you can try the "Tachometer" or a "Bullet..." chart.

Hope one of those helps you.

[Anonymous]

Thanks @ibarrau I used the tachometer which was perfect.