Adding an overlay with a hyperlink to a line chart
I work on a data engineering team, and we have a PowerBI report that includes a line chart showing how long it takes for data to be processed. Spikes in this graph are typically related to an incident (configured in our incident management platform) that captures outages and disruptions to our service. I would like to display those incidents over this line chart (shown as red dots on the graph below). Each dot would represent an incident or group of incidents that fired at a particular time stamp. When I hover over or click on a red dot, I would like to see a tooltip or dialogue panel with more information about the incident(s) including incident number and a hyperlink to the particular incident on our incident management platform. Assuming the underlying data model is working and we are able to correlate incidents pulled from our incident management platform with the data from the line chart, what kind of visuals could I use to create these dynamic overlaid lables with hyperlinks? If there are no existing visuals that would allow this, has anyone tried any plug-ins or custom solutions that they could share? I would appreciate any help 🙂 cc: jayendrans
How Do I keep Sales PY Calculation When a Filter is Applied?
Hi! I am an extreme novice and have scratched together some Dashboards in PBI with little to no knowledge of whether or not the way I am going abnout things is best practice. My issue is I have time series data formatted below that goes back 104 weeks by item I have a date table to roll up all of the various data sources I have so they have a consistent week ending date. (Although not neccesary for this dashboard as it only has one data source/retailer) And then I created a Date Filter table so I could use slicers to select 52/26/12 weeks time periods Using these calculations Since there is no column for Sales PY in my data I just want to make a command that finds the sales for the same item/brand etc for the same exact period/week last year and this is what I came up with after failing with SAMEPERIODLASTYEAR It appears to work when I don't have the date filter/slicer applied as shown below However there are a few issues... 1. Since my date table runs into the future it forward calculates the PY sales. I only want my data to go up to the most recent current year date 2. When I apply my date filter slicer to 52 weeks the PY sales dissappear as shown below. I fundamentaly can understand why they would as the filter is only showing data from the last 52 weeks and therefore I would assume it omits going back further to pull those PY dates. I just don't know how to go about fixing this Let me know if any other context is necessary. Thank you!
