Period Shown in Animated Bar Chart Race

[deplehehe]

Hi every one,

I am building a chart of cumulative trading amount of stocks through dates by using Animated Bar chart race. 

The Name field is Symbol, Value field is Cumulative, and Period filed is TradingDate. The racing works fine but the Period shown on the chart is 0 for every date. 

Is there a way that the period shown can be date data type? 

Here is sample of my data:

TradingDate	Symbol	TradingAmount	Cumulative
12-10-19	AAPL	1245	1245
13-10-19	AAPL	2245	3490
14-10-19	AAPL	3245	6735
15-10-19	AAPL	4245	10980
12-10-19	GOOGL	987	987
13-10-19	GOOGL	2187	3174
14-10-19	GOOGL	3387	6561
15-10-19	GOOGL	4587	11148
12-10-19	PYPL	349	349
13-10-19	PYPL	849	1198
14-10-19	PYPL	1349	2547
15-10-19	PYPL	1849	4396
12-10-19	EA	456	456
13-10-19	EA	1056	1512
14-10-19	EA	1656	3168
15-10-19	EA	2256	5424

[MAcaranduba]

What I've done was to create a new TradingDateAsNumber colum as a number, with the format yyyymmdd.

For that, we create a personalized column, in Power BI Desktop Query Editor, using the formula

= Date.ToText([TradingDate], "yyyyMMdd").

Then, change the type of the newly created column from Text to Number.

If we use that new date-as-a-number column in the Period field, the Animated Bar Char Race will take it as any other number and place it in the chart legend. It will not be pretty as 'mar-21' format, but al least the users will be able to follow the timeline of the data.

[v-shex-msft · Accepted solution]

Hi @deplehehe ,

Nope, I don't think it is possible to do custom on third party custom visual, maybe you can contact to the visual author for your requirement or use timeline chart to display graph based on the date period.

Regards,
Xiaoxin Sheng