I have this idea for a custom visualization that would be awesome for tracking how things change over time in Power BI.
Think about it: you have some data showing performance trends, maybe website traffic, project milestones, or even customer satisfaction scores. But you also want to highlight specific events that might have impacted those trends.
Here's the vision:
We'd have a chart (line chart, area chart, etc.) showing the performance trend.
Built right into the visualization would be a way to:
- Annotate a change: Briefly describe what happened and when (start date). A marker would appear on the chart at that point.
- Shade the impact period (optional): A toggle switch would let you select an end date, shading the timeframe the change was in effect.
- Interactive tooltip: Hovering over the marker or shaded area reveals a clear and concise explanation of the change and its connection to the performance trend (e.g., "Website traffic surge following the launch of a new marketing campaign explained in detail what we introduced into the system ").
- Annotation Library: An annotation library allows saving annotations for common changes. These can easily be applied across visualisations and shared between reports.
Imagine the benefits:
- Quickly see the impact of events on performance.
- Keep all the context within one visualisation.
- Easily update annotations as things change.
Let me know what you think about this idea! Would you find a function like this useful on your charts? Any suggestions for improvement are welcome!
I'm curious to hear if anyone else has encountered similar challenges. How do you currently visualise changes in your Power BI reports?
Looking forward to hearing from all the data visualization wizards out there!
Cheers,
Stevan Bodiroza
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow to use service principal for VNet data gateway connection to SQL Server
Service principal authentication is not supported for Azure SQL server connections when using an on-premises data gateway or a virtual network (VNet) data gateway. As a result we have to fallback to ...Andrei-Sokalau2 hours agoNew MemberNew3Views0likes0CommentsProvide a Read-Only / Source-Safe Mode for Schema Shortcuts in Lakehouse
Schema Shortcuts provide a much better management experience than individual Table Shortcuts because they preserve the source schema structure and allow multiple tables to be onboarded at once. Howev...Junghyoen4 hours agoMicrosoft EmployeeNew22Views8likes0CommentsAccess Variable Library in Semantic Models
Enable the Variable Library as a centralized location for storing all environment‑specific variables, allowing us to adjust them for promotion scenarios (e.g., from dev to prod) without relying on de...FreddyH15 hours agoAdvocate IINew920Views31likes2CommentsEnhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...dwramreddy16 hours agoRegular VisitorNew8Views0likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db20 hours agoNew MemberNew238Views2likes2Comments