cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
heytherejem
Post Prodigy
Post Prodigy

Visualisation Help!

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. 

 

 

Visual Example.png

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

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.


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

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
ibarrau
Super User
Super User

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.


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

Happy to help!

LaDataWeb Blog

View solution in original post

Thanks @ibarrau I used the tachometer which was perfect.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.