Forum Discussion
Creating dynamic percentile graphs (first post!)
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:
- 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?
- Average price of property at 50th, 70th and 90th percentiles by property size (based on dynamic slicers)
- 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!
1 Reply
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
