Creating dynamic percentile graphs (first post!)

[jefffen]

Hello I’m new to PowerBI so would appreciate the community’s help on this. I've tried researching but can't find the answer sadly.

Data set is property performance by revenues and occupancy rates (based on location, property type, size etc) as below:

Property ID	Property Type	Listing Type	Last Scraped Month	Zipcode	Neighborhood	Average Daily Rate (AUD)	Occupancy Rate LTM	Segment_Guests
11156	Apartment	Private room	31/07/2017	2011	Elizabeth Bay	$68	67%	Studio
12351	House	Private room	31/07/2017	2009	Pyrmont	$109	87%	Studio
13782	Loft	Entire home/apt	30/06/2017	2025	Woollahra	$105	53%	Studio
14250	House	Entire home/apt	31/07/2017	2093	Balgowlah	$500	39%	2 Rooms
14935	Apartment	Private room	31/07/2017	2016	Redfern	$66	80%	Studio
14974	Apartment	Shared room	31/07/2017	2016	Redfern	$46	69%	Studio
15253	Apartment	Private room	31/07/2017	2010	Darlinghurst	$115	79%	Studio
20865	House	Entire home/apt	31/07/2017	2041	Balmain	$503	46%	3 Rooms
26174	Apartment	Private room	31/07/2017	2023	Bellevue Hill	$82	47%	Studio
26741	Apartment	Entire home/apt	30/04/2017	2026	North Bondi	$214	28%	1 Room
27155	Apartment	Entire home/apt	30/09/2016	2037	Glebe	$201	64%	1 Room

I have added slicers in my report to filter by neighbourhood and property type etc. What are the exact steps I need to take to set this up so that the results and percentiles are dynamically calculated based on the slicers?

I’m trying to create 3 Graphs:

 

1. percentile graph of “occupancy rates” and “average price” in 10th percentile increments of occupancy performance (based on dynamic slicers). How do I also set the x-axis categories to read as 10th, 20th, 30th, etc percentiles?

1. Average price of property at 50th, 70th and 90th percentiles by property size (based on dynamic slicers)

 

1. Price by property type by month – at 90th percentile

 Thank you so much for your advice on this. Looking forward to hearing from the PowerBI community!

[Greg_Deckler]

I've never really gotten into using them but it seems like you would need to use something like PERCENTILE.INC or something along those lines?

https://msdn.microsoft.com/en-us/library/dn802548.aspx