Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Percentiles by group and date

Good morning community, 

I have tried all my tricks and I cannot figure out how to recreate the graph below in Power Bi. Please help!

For reference, my data includes individual-level data, each individual belongs to a department within the organization. The line in dark blue represents the mean of a specific measure for the entire organization. The line in light blue is the mean of the same measure for one specific department within the organization. The light green area is the score between the 25th and 50th percentile for all the departments in the organization and the light red area is the score between 50th and 75th percentile for all the department in the organization. To add complexity all the measures are calculated by date (month, quarter, year - in the graph you see the data by quarter). 


My question to you all is: 

how do I calculate departments percentiles by date? and how do I color in between lines?


Any direction would be extremely helpful, 


Warmest regards, 







Do you want to develop something similar or you look for exisitng such a visual?

If you look for a visual please check Power BI Visual Store.

If it is question regarding visual development so, I recommend you to check our public visual repositories to look at the examples.

I can suppose that you should use grouping bucket and put there date field and other fields may be used as measures from other buckets. Then, when your data is grouped by date, you will be able to calculate all necessery things and build areas and line using d3 library.

Please, provide more details to understand your issue more clearly.


Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals

Helpful resources

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors