Recently, I came across a visualization that aggregated data based upon a varying time scale. For those dates that were in the current quarter, weekly summaries were displayed, while for those dates that were not in the current quarter, quarterly summaries were displayed. Replicating this visualization within Power BI originally took the form of two visuals squished together with transparent backgrounds. The result was less than ideal and took a significant amount of formatting and alignment.
This recipe presents a method of creating a dynamic temporal scale that can be used within Power BI visualizations, such that a single visual can display different time scales simultaneously.
