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.
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 |
Solved! Go to 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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |