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