Forum Discussion
Prince change history chart
The purpose of this report is to provide quick and practical general information on the price history of our products and those of our competitors. In some cases, it may be relevant to have a historical curve to make comparisons in the price behavior of certain SKUs, and that’s why I would like to build this chart.
I thought of a logic to try to filter the number of dates, but I don’t have enough knowledge in Power BI to apply it. Maybe you can help me with its development or tell me if it is possible or not.
- Create a measure in which it is possible to see the price of one or more selected SKUs on the day before the selected date.
- Create another measure that compares the price on day D with the price on day D-1.
- Create a measure with the following conditional:
- If any of the selected SKUs show a variation different from zero (measure 2), the date in question will be kept on the chart. Otherwise, the date will not appear.
it is possible to see the price of one or more selected SKUs on the day before the selected dateThis is back to my original question - how many price changes do you expect to happen at most per product per day? A single change?
In general you're on the right track. Change based reports are much better than snapshot based reports (in my opinion) but they are harder to implement, so you need to be clear in your sample rate requirements before you tackle this.
That is correct! Each product can have it's price changed only once at a day.
The frequency of that change varies a lot, however. There are some products that are having a steady price for years, while others tend to change more frequently. What i can tell to you is that "Rival" produts (that being SKU's that compete for the same market segment) tend to have the same price behaviour.I would be leaning towards a box and whisker chart type, and would definitely include the number of changes in the chosen interval. If you don't have too many products you could use small multiples.