Quartile visualization

[Anonymous]

Hi,

I would like to visualize a quartile ranking in Powerbi looking like the attached image below.

I'm categorizing time spent per person on activities.

The axis represents the quartiles (so 25,50,75 and 100%) while the triangles indicate specific values.

The major issue for me is how to fix the axis so that it is not linear: for example: the first quartile can go from 0 to 0,34% while the second quartile can go from 0,34 to 1,67% etc... 

Anyone has an idea to help me on this?

Thanks

[amitchandak]

@Anonymous 

In power bi you have box-and-whisker visual for that

https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-box-and-whisker-plots/

If you want to use percentile function https://docs.microsoft.com/en-us/dax/percentile-exc-function-dax

percentile.* function. You may also explore bullet chart

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380755?tab=Overview

[Anonymous]

Hi, 

Thanks for your answer!

Unfortunately, I really want to have the visual as attached in my image because i want to use it as a filter..

M