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
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Partners Overview
    • Solutions Partners
    • BI Specialized Partners
    • Power BI CSOs
    • Fabric Partner Community
    • Training
    • Getting started
      • Overview
      • 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
    • Power BI forums
    • Updates
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish forums
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • 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
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    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: 

    Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

    • Power BI forums
    • Galleries
    • Data Stories Gallery
    • Re: Global CO2 Emissions Analysis

    Re: Global CO2 Emissions Analysis

    05-03-2023 00:57 AM - last edited 05-03-2023 01:00 AM

    arun_tanwar_91
    Frequent Visitor
    1881 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Pragati11
    Super User Pragati11
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Global CO2 Emissions Analysis

    ‎02-01-2022 08:42 AM

    Hello Everyone,

     

    This is my first ever post to the Data Stories Gallery here on Power BI Community.

     

    CO2 emissions globally are impacting the world in different ways.

    I have tried to create some analysis at Region and Country level to see how the impact has been overtime and whether the countries are taking any measures to control their CO2 emissions or are getting worse.

    This analysis looks at some insights around -

    • trend around CO2 emissions for Regions/Countries overtime
    • at what intensity the CO2 emissions is increasing
    • which countries have improved overtime by taking measures on limiting their CO2 emissions
    • which countries have gone worse overtime
    • what is the biggest source of CO2 emissions
    • growth rate of emissions overtime to check if the countries have improved or got worse

    The data for this analysis has been taken from the freely available data repository on git-hub:

    https://github.com/owid/co2-data

     

    Look forward to the valuable feedback from the community members.

     

    Thanks,

    Pragati

     

     

     

     

     

     

    eyJrIjoiMjk1OTQwNTgtN2Y0Yi00ZWVhLWExMWUtMjRlMjI5ODZkNzBhIiwidCI6Ijk5Y2FmZTRjLWVlYTktNGFhNy1hMzUwLTQ5YzhkNjNhOTE0YiJ9

    Best Regards,

    Pragati Jain


    MVP logo


    LinkedIn | Twitter | Blog | YouTube 

    Did I answer your question? Mark my post as a solution! This will help others on the forum!

    Appreciate your Kudos!!

    Proud to be a Super User!!

    Labels:
    • Labels:
    • Education
    • How To
    • Other
    • Technology
    Message 1 of 11
    5,648 Views
    9
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    arun_tanwar_91
    arun_tanwar_91
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-07-2023 06:48 AM

    Hello. 

    How have you performed Data Munging ? "Countries Emissions" table can be created as it contains mostly measures but how have you prepared "Countries" table ?

    Will be helpful to perform along with you.

    P.S : Above attached file isn't available. Can you please look into this. 

     

     

     

    Message 9 of 11
    2,248 Views
    0
    Reply
    Pragati11
    Super User Pragati11
    Super User
    In response to arun_tanwar_91
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-25-2023 05:38 AM

    Hello @arun_tanwar_91 ,

     

    Which attaced file are you talking about?

    Best Regards,

    Pragati Jain


    MVP logo


    LinkedIn | Twitter | Blog | YouTube 

    Did I answer your question? Mark my post as a solution! This will help others on the forum!

    Appreciate your Kudos!!

    Proud to be a Super User!!

    Message 10 of 11
    1,989 Views
    0
    Reply
    arun_tanwar_91
    arun_tanwar_91
    Frequent Visitor
    In response to Pragati11
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-03-2023 12:57 AM

    Hello. Thank you for replying. Actually attached POWER BI Dashboard was not opening before but, now working absolutely fine. 

    I am asking can you help us how you performed Data Cleaning on the dataset of this project. 

     

     

    Message 11 of 11
    1,881 Views
    0
    Reply
    sweetstar
    sweetstar Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-31-2022 06:33 PM

    how did you do the second multi-rows bar chart? 

    Message 7 of 11
    3,626 Views
    0
    Reply
    Pragati11
    Super User Pragati11
    Super User
    In response to sweetstar
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-01-2022 01:29 AM

    Hi @sweetstar 
    That is sparklines in Power BI.

    Best Regards,

    Pragati Jain


    MVP logo


    LinkedIn | Twitter | Blog | YouTube 

    Did I answer your question? Mark my post as a solution! This will help others on the forum!

    Appreciate your Kudos!!

    Proud to be a Super User!!

    Message 8 of 11
    3,611 Views
    0
    Reply
    Preek
    Preek
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-27-2022 08:03 AM

    A very cool dashboard Pragati. But I had two questions, how did you show the top 5 countries for each year ? And the second question is how did you create the emissions overtime for each country ? Thank You. 

    Message 4 of 11
    4,314 Views
    0
    Reply
    Pragati11
    Super User Pragati11
    Super User
    In response to Preek
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-28-2022 03:54 AM

    HI @Preek ,

     

    Answers to your questions below:

    • The top 5 countries for each year are shown by applying the visual level filter on my tooltip based on total CO2 emissions.
    • Emissions overtime data is available to me, so just created a trend chart using it.

     

    Best Regards,

    Pragati Jain


    MVP logo


    LinkedIn | Twitter | Blog | YouTube 

    Did I answer your question? Mark my post as a solution! This will help others on the forum!

    Appreciate your Kudos!!

    Proud to be a Super User!!

    Message 5 of 11
    4,287 Views
    1
    Reply
    Preek
    Preek
    New Member
    In response to Pragati11
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-29-2022 01:03 AM

    Thank you Pragati for your reply 

    Message 6 of 11
    4,153 Views
    0
    Reply
    mariomarin82
    mariomarin82
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-17-2022 08:43 AM

    Hi I have 2 doubts

    One, how you create the Growth rate year by year

    Second, where you can download a table with all coordinates to create the maps

    Thanks!

    Message 2 of 11
    4,607 Views
    0
    Reply
    Pragati11
    Super User Pragati11
    Super User
    In response to mariomarin82
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-24-2022 08:35 AM

    Hi @mariomarin82 ,

     

    Growth Rate is a measure that is caluclated by comparing the current year emissions versus last year emissions.

    A measure something like below:

    DIVIDE(
        ([This Year] - [Last Year]), [Last Year], 0
    )

    It's a standard metric used in different scenarios.

    All the data that I have used is on the gitHub repository link that i have shared in the description above. It has got all the demographic information required to create map visuals on the report.

     

    Best Regards,

    Pragati Jain


    MVP logo


    LinkedIn | Twitter | Blog | YouTube 

    Did I answer your question? Mark my post as a solution! This will help others on the forum!

    Appreciate your Kudos!!

    Proud to be a Super User!!

    Message 3 of 11
    4,568 Views
    1
    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
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices