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
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • 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
      • Overview
      • Guided learning
      • Documentation
      • Webinars
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign In
    • ·
    • Help
    Go To
    • Galleries
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • MBAS Gallery
    • MBAS Gallery 2020
    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
    • Re: COVID-19 NSW Transport Impact

    Re: COVID-19 NSW Transport Impact

    09-11-2020 00:55 AM - last edited 09-11-2020 00:58 AM

    Tings
    Advocate II
    20498 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Tings
    Tings Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    COVID-19 NSW Transport Impact

    ‎06-30-2020 03:13 PM

    Information

     

    This report combines OPAL tap-on/tap-off data from NSW Trains, Ferries, Buses, Light Rail & Metro. We use these data to compare public transport utilisation year over year (2020 vs 2019). The aim is to understand the impact of COVID-19 on passenger levels across all modes of public transport, using 2019 as our baseline.

     

    The common dimensions available in the report include Service, Fare Type and Transport Mode. A definition of these can be found below:

     

    Service: Refers to the service where the tap-on/tap-off occurred e.g. Manly Ferry

    Fare Type: Refers to the type of fare for which the tap-on/tap-off occurred e.g. Adult

    Transport Mode: Refers to the mode of transport where the tap-on/tap-off occured e.g. Train

     

    Data Sources

    All data is sourced from the NSW Transport Open Data website - links are below:

    Ferry: https://opendata.transport.nsw.gov.au/dataset/opal-trips-ferry

    Bus: https://opendata.transport.nsw.gov.au/dataset/opal-trips-bus

    Train (Includes Metro): https://opendata.transport.nsw.gov.au/dataset/opal-trips-train

    Light Rail: https://opendata.transport.nsw.gov.au/dataset/opal-trips-light-rail

     

    Key Metrics

    Passengers 2019: Sum of Passengers for 2019 (Excluding months that are yet to occur in 2020 e.g. September).

    Passengers 2020 Sum of Passengers for 2020

    Absolute Change Year over Year: Passengers 2020 - Passengers 2019

    Percentage Change Year over Year: (Passengers 2020 - Passengers 2019) / Passengers 2019

    Passengers Current Reporting Period: Sum of Passengers for the latest reporting month

    Passengers Current Reporting Period Previous Year: Sum of Passengers for the

     

    eyJrIjoiNzcxNTdlY2ItYjFhYS00YjkyLThkMmEtMTQwYjVlYzExNjA0IiwidCI6ImQyYWY4YjViLTlhN2UtNGM4NS1hM2ZkLWI2OWE2Njk4YjdkNiJ9

    Labels:
    • Labels:
    • COVID-19
    • Featured
    Message 1 of 12
    23,172 Views
    15
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    rTAHERI
    rTAHERI
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎02-01-2021 10:16 AM

    nice

    Message 12 of 12
    4,248 Views
    0
    Reply
    Chacos
    Chacos Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎12-17-2020 11:47 AM

    mdbuzzer, 

    This is an awesome dash! 

    Did you ever think to create a youtube video? Even with high level tips, how to create similar tabbed vizuals.

     

    Thanks!

    Message 11 of 12
    7,973 Views
    1
    Reply
    Chacos
    Chacos Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎10-28-2020 10:13 AM

    How did you guys create the "tab effect" for the top left quadrent's viz? (the Percentage Change by Month (2020 vs 2019)

    Seams like tabs are buttons and then you used bookmarks and then action to hide or unhide the viz, correct?

    Message 9 of 12
    15,203 Views
    0
    Reply
    mdbuzzer
    mdbuzzer Helper I
    Helper I
    In response to Chacos
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎10-29-2020 01:29 AM

    you use Powerpoint and create backgrounds with tabs and darken the colour of the tab you are currently on, use that background image from powerpoint on Power Bi and just add buttons

     

    Page 1 Tab.jpg

    Message 10 of 12
    15,097 Views
    1
    Reply
    mdbuzzer
    mdbuzzer Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎09-08-2020 01:20 AM

    How did you manage to get that header/announcement bar to be dynamic like that ? Is there a specific visual to use ?

    Message 7 of 12
    20,744 Views
    2
    Reply
    Tings
    Tings Advocate II
    Advocate II
    In response to mdbuzzer
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎09-11-2020 12:57 AM

    Hi @mdbuzzer ,

     

    It's a third party visual called "Scroller'". You can import it into your desktop file from the marketplace.

     

    Cheers,

    Tom

    Message 8 of 12
    20,497 Views
    0
    Reply
    Aamir_khan
    Aamir_khan Helper V
    Helper V
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-28-2020 06:03 AM

    nice work. possible to share the pbix file

    Message 2 of 12
    21,382 Views
    3
    Reply
    Tings
    Tings Advocate II
    Advocate II
    In response to Aamir_khan
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎09-11-2020 12:55 AM

    Hi @Aamir_khan ,

     

    You can download the file at: www.sparkbi.com.au

    Message 3 of 12
    20,498 Views
    1
    Reply
    Chiara-Miani
    Chiara-Miani
    New Member
    In response to Tings
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎12-10-2020 09:49 AM

    Hi! Really nice work!

    I'd like to see the file to understand how you did many things I'm interested in, but I can't download it from the link above 😞

    Can you please share it again?

     

    Thank you so much!

    Message 6 of 12
    10,313 Views
    1
    Reply
    Chacos
    Chacos Helper I
    Helper I
    In response to Tings
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎10-05-2020 02:05 PM

    COVID-19 NSW Transport Impact - can you please allow download for this one?
    On the SparkBI site it's not available, it's not in the SharePoint.

    Message 5 of 12
    18,207 Views
    0
    Reply
    Aamir_khan
    Aamir_khan Helper V
    Helper V
    In response to Tings
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎09-13-2020 03:18 AM

    Thanks, how you refresh the data can you please share the details.

    Message 4 of 12
    20,357 Views
    0
    Reply
    Preview Exit Preview

    never-displayed

    You must be signed in to add attachments

    never-displayed

    Additional options
    You do not have permission to remove this product association.
     

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • 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

    • © 2021 Microsoft
    • Follow Power BI
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks