March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
03-05-2019 05:43 AM - last edited 03-06-2019 22:14 PM
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:
eyJrIjoiMWE4YWY1NWEtMzczZC00NDE3LTk4ZmUtM2U2MzFiNGZkNDQ5IiwidCI6ImExMTdlOGM2LWRhYTMtNDFlMi1iZDJhLTgyYzUwMmZlMzM4NCJ9
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.
This looks great, can some of the text (water, weather) and images (weather clouds, KPI arrows) be made dynamic to the values?
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.