cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deplehehe
Frequent Visitor

Period Shown in Animated Bar Chart Race

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:

TradingDateSymbolTradingAmountCumulative
12-10-19AAPL12451245
13-10-19AAPL22453490
14-10-19AAPL32456735
15-10-19AAPL424510980
12-10-19GOOGL987987
13-10-19GOOGL21873174
14-10-19GOOGL33876561
15-10-19GOOGL458711148
12-10-19PYPL349349
13-10-19PYPL8491198
14-10-19PYPL13492547
15-10-19PYPL18494396
12-10-19EA456456
13-10-19EA10561512
14-10-19EA16563168
15-10-19EA22565424
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
MAcaranduba
Regular Visitor

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.

Sem título.png

 

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.