Forum Discussion
Date Percentiles and Dynamic Lines
Good afternoon,
Does anyone know how to get percentiles from a date range? It seems Power BI can calculate percentiles from "number" data types, but not dates. Furthermore, I'd like to add a slicer and line so that I can toggle the visualization and answer questions like "If I finish at 10/31/2026, what percentile is that?" and "If I want to finish at the 90th percentile, what finish date is that?" based on my data.
I'd post my sample workbook, but I can't see where to do that.
Thanks in advance!
4 Replies
- parry2k
Super User
Anonymous You can share sample using one drive/google drive with the expected output. Remove any sensitive information before sharing.
- parry2k
Anonymous not sure what else to tell, share with whatever tool you can share files with. sorry not sure what else to tell.
Hi Anonymous
You can paste the table directly into the post.
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityBest Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
