search

dairecoleman / parkrun-app

project for learning app development, hope to make something useful
MIT License
1 stars 0 forks source link

Power BI Visual: All results scatter plot #4

Open dairecoleman opened 1 month ago

dairecoleman commented 1 month ago

What info can be gleaned from the parkrun 'All Results' Summary table

dairecoleman commented 1 month ago

Added a visual: Need to do funky stuff with duration/time formatting

See here for soloution explanation: https://community.fabric.microsoft.com/t5/Desktop/Display-time-in-Y-axis-using-Power-BI-clustered-column-chart/m-p/387963

dairecoleman commented 3 weeks ago

image

All parkrun results categorically spaced and possible to filter by year + event w/ slicer

dairecoleman commented 3 weeks ago

Adding a trendline: need continuous data which is bad for viewing visual over several years.

Fix https://forum.enterprisedna.co/t/trend-line-not-available-in-line-chart/8453/4 'Instead of the auto trendline feature, you can develop a measure that will estimate a linear regression line for your data and then add that to your line chart as a third data series. This will allow you to use a categorical x axis.'

Watch vid and implement: https://www.youtube.com/watch?v=d1kHgFULcko