Enclosed a spreadsheet with the naps of the day in power query format.
slicers are also used to group together selections and can be searched by time or track.
to update just press refresh all
enjoy and hope it's useful
Naps for the day
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
Last edited by MemphisFlash on Wed Mar 30, 2022 10:54 am, edited 1 time in total.
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
example of a race
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
For those who are unsure about the refresh, if you open "Queries And Connections" before you hit refresh
you will see the panel on the right hand side. When you hit refresh you will see a spinning wheel where the table icon is.
When that stops spinning everything has been updated.
If you click on the icon next to horses name you get additional info.
you will see the panel on the right hand side. When you hit refresh you will see a spinning wheel where the table icon is.
When that stops spinning everything has been updated.
If you click on the icon next to horses name you get additional info.
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
- bigpapaperry
- Posts: 18
- Joined: Sat Feb 13, 2021 1:18 pm
Excellent bit of kit thank you, now to spend my weekend trying to work out how you did it.
i do love a bit of Excel
It wont update or refresh as my version of Excel is older than yours
i do love a bit of Excel
It wont update or refresh as my version of Excel is older than yours
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
updated sheet as error in slicers not working dynamically on original
You do not have the required permissions to view the files attached to this post.