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
    • Green Defense - Power BI Visualization by Third I
    Accepted Solution

    Green Defense - Power BI Visualization by Third I

    03-05-2019 05:43 AM - last edited 03-06-2019 22:14 PM

    ThirdI
    Advocate IV
    4775 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    ThirdI
    ThirdI Advocate IV
    Advocate IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Green Defense - Power BI Visualization by Third I

    ‎03-05-2019 05:43 AM

    Third I developed a Power BI report to measure carbon footprint and overall energy expenses incurred by consumers. The report was built using powerful visualizations in Power BI by converting the data sourced from various energy consuming appliances into a single set of analytics for real-time actionable insights along with energy consumption forecasts & recommendations.

    For consumers, the goal is to drive awareness and conservation of natural resources through compelling analytics, insightful visualizations, and targeted actionable conservation recommendations.

     

    The Green Defense Report by Third I enables end consumers to gain better insight into their energy consumption patterns and provide economic benefits along with a positive impact on the environment.

    It offers powerful analytics on daily energy consumption, predicted consumption for the day and calculates monthly bill based on the daily consumption pattern of energy resources like electricity, gas, and water. The report also enables the users to measure their daily carbon footprint and shares necessary recommendations to reduce them, thereby enabling users to monitor their energy consumption from a single dashboard and take immediate actions based on the recommendations.

     

    Questions it helps answer:

    • What is the difference in energy consumption from the previous day?
    • What are the projected monthly costs for resources like electricity, gas, and water?
    • How does their consumption of different energy resources affect the environment?

     

    eyJrIjoiMWE4YWY1NWEtMzczZC00NDE3LTk4ZmUtM2U2MzFiNGZkNDQ5IiwidCI6ImExMTdlOGM2LWRhYTMtNDFlMi1iZDJhLTgyYzUwMmZlMzM4NCJ9

    Preview file
    74 KB
    Third I_GreenDefense_Report.pbix
    Labels:
    • Labels:
    • Global Challenges
    • Health
    • Lifestyle
    • Other
    Message 1 of 3
    4,775 Views
    8
    Reply
    1 ACCEPTED SOLUTION
    ThirdI
    ThirdI Advocate IV
    Advocate IV
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-26-2019 05:47 AM

    Yes, this can be achieved by following below steps -

    1. Create the measure which contains threshold based values on the basis of required value.

    2. Create a relationship between required tables with cross filter enabled on both sides.

    3. Now create a visual holding column of the required related tables created in Step 2.

    4. Use the measure created in Step 1 in the visual level filter of created visual in Step 3 and apply the required filtering. 5. Refresh the data and test the changes.

    Message 3 of 3
    4,054 Views
    1
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-25-2019 07:19 AM

    This looks great, can some of the text (water, weather) and images (weather clouds, KPI arrows) be made dynamic to the values?

    Message 2 of 3
    4,111 Views
    1
    Reply
    ThirdI
    ThirdI Advocate IV
    Advocate IV
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-26-2019 05:47 AM

    Yes, this can be achieved by following below steps -

    1. Create the measure which contains threshold based values on the basis of required value.

    2. Create a relationship between required tables with cross filter enabled on both sides.

    3. Now create a visual holding column of the required related tables created in Step 2.

    4. Use the measure created in Step 1 in the visual level filter of created visual in Step 3 and apply the required filtering. 5. Refresh the data and test the changes.

    Message 3 of 3
    4,055 Views
    1
    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