Developing dynamic dashboard metrics
Dashboard tiles snapshots of report visuals. The values of the measures and columns used in the pinned report visual are refreshed, but modifications to the report, such as filters or formatting, are not reflected in the dashboard. Therefore, it's necessary to develop dynamic logic in the data model and measures that keep dashboard tiles current across time. Additionally, dynamic logic simplifies the user experience of interacting with reports and the dashboard report development process.
In this recipe, two columns are added to the date dimension table and used to drive dashboard report visuals. Additionally, a measure is created to provide a target value to support comparison with a KPI.
How to do it...
Dynamic date columns
- Identify grain(s).
- Dashboards are usually focused on the current year, month, or week, and trends within the current year or recent history
- Whether calendar or fiscal periods, columns associating dates to these values enhances and simplifies...
