Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Time series with specific dots

Hello!

 

Could somebody please help me. I would like to find a means to get time series plot with some specific dots (i.e. mixing a time series plot with a scatter plot).

 

I have three csv files. One is a main with current currencies. Two another are with specific dots.

I would like to use one color for specific dots per file (for example yellow color for orders_open.csv file and red color for orders_close.csv file).

 

Main csv file:

Time (UTC);Ask;Bid;AskVolume;BidVolume
2019.06.03 00:00:00.136;1,11739;1,11736;1;2,44
2019.06.03 00:00:00.608;1,11739;1,11736;3,5;2,62
2019.06.03 00:00:00.711;1,11737;1,11736;1,12;2,25
2019.06.03 00:00:00.814;1,11735;1,11731;1,5;3,56
2019.06.03 00:00:00.929;1,11733;1,11731;1;1,69
2019.06.03 00:00:01.031;1,11731;1,11727;1,25;2,25
2019.06.03 00:00:01.235;1,11732;1,11727;12,49;1,31
2019.06.03 00:00:01.337;1,11732;1,11727;13,22;1,31

orders_open.csv file:

1.11736;2019-06-03T00:00:00.136
1.1178;2019-06-03T00:31:35.457
1.11757;2019-06-03T01:19:21.016
1.11835;2019-06-03T01:41:32.420

orders_close.csv file:

1.1178;2019-06-03T00:31:35.457
1.11757;2019-06-03T01:19:21.016
1.11835;2019-06-03T01:41:32.420
1.11881;2019-06-03T03:20:54.395
1.11858;2019-06-03T03:25:56.587

 

This is similar plot what I would like to make:

 

 

Thank you in advance!

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

    As searched, i am unable to find any custom visual like this in Power BI Market.

    Maybe you could create a custom visual with R/Python.

     

    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.