How to capture the spike in data for a particular product on the same day?

[Anonymous]

How to capture the spike in data for a particular product on the same day,lets say the price keep changing and we have the following data points to be plotted as a line graph,

1.Time stamp

2.Product ID

3.Price of the Product

All I want to do is to be capable of comparing the product price and show the spike alone in a different color.

[v-juanli-msft]

Hi @Anonymous 

Would you like to get the max price per day to show on the line graph?

If so, you could create a column to get "date" from "date/time" column,

Date=[datetime].DATE

then create a measure to get the max price per day

max price=CALCULATE(MAX([Price]),ALLEXCEPT(Table,[Date]))

Then you can color the specific values conditionally as below:

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

If not, please let me know.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for responding,I also need to consider the time,even the seconds should be taken into account for identifying the spike.Can you please help on this.

@v-juanli-msft