04-29-2021 02:08 AM
Hello everyone, hope you are all healthy and safe.
I have come up with the solution for Candlestick chart. The data which is required by the candlestick chart I have derived with the help of single DAX i.e. SUMMARIZE function.
The Chart need 5 basic values
2) Open value
3) Close value
4) High value
5) Low value
these values I have derived from the large dataset which I have of Ecommerce domain.
Following is the DAX I have used
I just downloaded Candle stick chart for Power BI however I cannot find Data Color and data table under this visual. hence I cannot populate data on the chart. Please kindly help out
I might not be clear with my question. The question is how to have the open value like the 510 in the example above shown on the chart
I really appreciate if someone can help out
Its a daily data for retail shop.
Open value is when I am opening my shop in the morning then what is my first sale of the day by any customer, similar for the close value what is my last sale when I am closing my shop.
Hope I have answered your question. Let me know in case of anything.