Our business is generating a data point which is being represented over a long range of time as so:
The actual graph that the business wants to represent is only the dips (i.e. the time whenever the plot goes to the lowest value), and all these plots need to overlap with each other and be represented like the following:
The end result only has to be the bottom graph that needs to be built in Power BI. The end user is going to select a date in the front end according to which the number of lines in the bottom graph should increase or decrease. This will depend on the number of โdipsโ are there in the date range selected.
