Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.