skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Australian school terms and public holidays by sta...
    Accepted Solution

    Australian school terms and public holidays by state

    10-18-2016 20:39 PM - last edited 11-03-2016 11:28 AM

    rbbi
    Advocate II
    2083 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    rbbi
    rbbi Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Australian school terms and public holidays by state

    ‎10-18-2016 08:39 PM

    Australia has eight states and each one has its own schedule of school terms/holidays that roughly coincide in four terms. There's also variation in public holidays, some of which are observed nationaly, others occuring in one or more states. When you work with schools around the whole country, or even if you're going on vacation in (or even near!) another state and want to avoid the holiday crowds, it's nice to be able to see this information in a graphic rather than the text-based lists available from government web sites.

     

    In this report I've used data generated in SQL Server from term and holiday dates. It's formatted specifically for the report, allowing a horizontal view by state. The colour scheme is from web sites advising on colours that are helpful for people living with colour-blindness issues. I've also added tooltips that describe each type of day and the names of public holidays, plus a half-day indicator for "pupil-free days" (i.e. staff-only days for development activities) that occur in some states at various times.

     

    I'm happy with the result as something that's publicly accessible. It replaces a paper grid report that my company used to distribute internally that was tedious to produce and usually inaccurate.

     

     

     

    eyJrIjoiM2YyYjllNGEtNDE5Ni00YjM0LWFjOWQtMTZlZjFkNTU3NGJhIiwidCI6IjA1ZjI2ZDdiLWJjYWYtNDc3My05NDM2LTJlOTI1YWVmMzhkNyJ9

    Preview file
    72 KB
    Labels:
    • Labels:
    • Education
    • Other
    Message 1 of 5
    2,083 Views
    2
    Reply
    2 ACCEPTED SOLUTIONS
    osoosh
    osoosh Advocate III
    Advocate III
    In response to rbbi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-02-2016 08:15 PM

    hi @rbbi go to the options menu and edit your message (see below the 3 dots on right hand side)

     

    Capture.PNG

    copy the power bi link and paste it back then save your message.

    Message 4 of 5
    2,928 Views
    0
    Reply
    Jessica
    Microsoft Jessica
    Microsoft
    In response to rbbi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-03-2016 11:29 AM

    Thanks for pinging me, @rbbi! Your report should be visible to everyone again. 🙂

    Message 5 of 5
    2,916 Views
    0
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    osoosh
    osoosh Advocate III
    Advocate III
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-02-2016 07:10 PM

    @rbbi Hi there, you might want to edit your post and save it again since it says content not available. I had previous issues before as per this post content not available !

    Message 2 of 5
    2,073 Views
    0
    Reply
    rbbi
    rbbi Advocate II
    Advocate II
    In response to osoosh
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-02-2016 08:10 PM

    thanks for checking this out @osoosh but I can't see any edit functionality on the post. @Jessica can you possibly help me with this one? thanks

    Message 3 of 5
    2,066 Views
    0
    Reply
    Jessica
    Microsoft Jessica
    Microsoft
    In response to rbbi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-03-2016 11:29 AM

    Thanks for pinging me, @rbbi! Your report should be visible to everyone again. 🙂

    Message 5 of 5
    2,917 Views
    0
    Reply
    osoosh
    osoosh Advocate III
    Advocate III
    In response to rbbi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-02-2016 08:15 PM

    hi @rbbi go to the options menu and edit your message (see below the 3 dots on right hand side)

     

    Capture.PNG

    copy the power bi link and paste it back then save your message.

    Message 4 of 5
    2,929 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices