A percentile is a number denoting the position of a data point within a numeric dataset by indicating the percentage of the data points with an equal or lesser (assuming it's inclusive) value. Percentiles can be used to understand test scores, stock values, health indicators, and other values. This week, we will use them to look at blood glucose (blood sugar) measurements.
Since blood sugar changes as we eat, it's helpful to look at data based upon the time of day or in relation to meal time. That is what we are visualizing this week. We are looking at measurements for multiple days and visualizing percentiles for each time of day with reference lines overlaid to show where values are in or out of range. The visual below is created from the line chart core visual - no custom visuals needed.
To complete the challenge:
- Get the data.
- Split the date and time into separate columns.
- Create measures for the 5th, 25th, 50th, 75th, and 95th inclusive percentiles.
- Create a chart with time of day on the x-axis and blood glucose percentiles on the y-axis. Each percentile should be represented by a line. The 95th and 5th percentile lines should be dashed. The 25th, 50th, and 75th percentile lines should be solid. There should be light shading in between the 75th and 95th percentile lines and between the 5th and 25th percentile lines. There should be medium shading between the 25th and 75th percentile lines.
- Label the percentile lines directly in the chart next to the lines and hide the legend.
- Add reference lines for the values 80 and 180.
Data for this challenge can be found on Data.World at https://data.world/mlongoria/wow2024wk49.
There is a single table in the dataset.
Note: Data.World requires you to create a free account to access the data. You may use the Data.World connector in Power BI or download the file to your local machine and connect to it there.
