Display 10th and 90th percentiles over TIME

[curibe]

Hello,

I have a data set that I would like to show the 10th and 90th percentile for a given month. Is there any way to accomplish this? I know there is a custom visual to show percentiles but it only shows percentiles and I need to show other lines of data on the visual. I also know there is an 'analytics' tool to show percentiles but it just shows the constant line not per month. Looking for something like this:

https://www.bing.com/images/search?view=detailV2&id=A9E70738138E927186094603E58C4604A12D8C68&thid=OI...

Thank you!

[Anonymous · Accepted solution]

Have you tried creating a measure using PERCENTILE.INC?

https://docs.microsoft.com/en-us/dax/percentile-inc-function-dax

Perc10 = PERCENTILE.INC ( [Column], 0.1 )

Perc90 = PERCENTILE.INC ( [Column], 0.9 )

Just a quick shot.

Regards