Power BI: Web Analytics Time Series with Calculation Group and Custom Conditional Formatting. 

This project was created by using a mock dataset from Google Analytics. The data shows overall web traffic by device type in different time periods.  Creating a Time Series Analysis can result in many measures that have similar calculations. I used Tabular Editor (an external tool from Power BI) to create a Calculation Group that helps to reduce the number of measures required to create the visualizations. However, applying conditional formatting to a Calculation Group can be challenging, so I also created some additional measures to customize the formatting for the specific calculation items.

Please see my DAX for all calculations and measures on GitHub.

 

Check my homepage here: Siri Shultz - Power BI