Quartile visualization

Question

Hi,&nbsp;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.&nbsp;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...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Anyone has an idea to help me on this?&nbsp;Thanks

amitchandak · Answer

Anonymous&nbsp;
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/
&nbsp;
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 · Answer

Hi,&nbsp;Thanks for your answer!&nbsp;Unfortunately, I really want to have the visual as attached in my image because i want to use it as a filter..&nbsp;M

Forum Discussion

Quartile visualization

2 Replies

Related content

quartile ranking

Column Visual / quartiles based on revenue

Quartiles Calculated Columns

Quartiles and average per quartile

Dynamic Quartiles