Identify date of first change in value of another column - Price changes

[shoaibalvi]

Hi all,

I have a small issue - I am terrible at DAX (just beginning) so no wonder I can't get it to work, but eager to learn!

I have a line chart with small multiples enabled. What this line chart does is, it tracks average of "Gross Price per Product" (y-axis) over time ("Billing Date" on x-axis) for each customer ("Customer Name" on small multiples). I want to be able to see that if there was any price change, did it occur consistently around the same time for all customers?

Though the line chart with its small multiple clearly shows the fluctuations in prices over time for each individual customer, its difficult to establish whether this occured on or around the same date unless I have a verticle line running across the visualisation that dynamically moves according to the earliest date on which a price change was detected. 

To simplify, a sample dashboard (Pbix) file, and an anonymised source table have been uploaded here.

In focus mode, the "change in gross price per customer over time" visualisation looks like this at the moment if you select the first bar in the top left visual titled "Number of distinct price points per product"

Now I need verticle lines running across the whole visualisaiton (not customer specific) that identify the point in time when the gross price showed the variation for the FIRST TIME only. Like this:

I have just drawn two lines in Teal and Purple to match the data line colors in the visualisation (apologies for the crookedness; did that using the snippet tool!). But the purpose is that PBI reads the data and identifies that under each distribution channel (HC or PS), when was the first time the price showed a change and then draws a verticle lines throughout for the same colour; this will help users have a reference point as they scroll down through the small multiples to view different customers. The purpose is that users should be able to readily identify if any particular customer got favourable or unfavourable prices for any duration of time because all price changes should ideally affect all customers at the same time. 

Any help on this would be greatly appreciated! Thanks!!

Regards,

Alvi

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[shoaibalvi]

Hi @lbendlin - a sample Pbix file and sample data have already been provided above in the google drive link.

[lbendlin]

identify the point in time when the gross price showed the variation for the FIRST TIME

Please define "variation".  How big of a change is considered a variation?

You can programmatically add a couple of X axis constant lines

and then show or hide them as needed.