Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
1) Date
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
eyJrIjoiNTAyYjU5M2UtYmI4Mi00OGU0LWI5YWEtYjlkNjc2NmJiOTljIiwidCI6Ijg0MmU0ZTBlLTFjNjMtNDE0Ny1iNWJjLTJiOGJhZWQyZjk5OCJ9
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
Regards
Leo
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
Leo
Hi Jessie,
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.
Best regards,
Pooja Darbhe