Wenchang Han on 03 Dec 2014 08:40:49
Can we add sparkline support to tables and matrix? Native Excel PivotTable supports it.
http://www.tips-for-excel.com/wp-content/uploads/2011/07/Picture117.png
Rien Hu (administrator) on 21 Dec 2021 00:35:18
12/20/21: The feature was shipped as Preview Feature in the December 2021 Update.
We're in the process of planning and developing the feature! Look out for it in the coming months.
- Comments (106)
RE: Sparkline
Please include this in the next update.
RE: Sparkline
I agree - sparklines would be a great addition to the visuals.
RE: Sparkline
Sparkline is liked by most, please have it as a feature.
RE: Sparkline
please add sparklines that automatically use the date dimension/table defined in a model and make it configurable. Also ensure that last value is always posted at end of the sparkline (see E.Tufte for the true examples). Hope this comes soon!
RE: Sparkline
This would be so helpful!
RE: Sparkline
A lot of focus needs to be put into Tables and Matrix visuals. A lot of times, a table of summarized data showing multiple metrics and little sparklines for any trending can provide way more insight that any fancy chart.
Sparklines, conditional formatting, icon sets and ability to expand with a plus (in matrix visual) are must have features in the table/matrix visual.
Actually, all the Power BI Team needs to do is take a good hard look at the Excel Pivot tables and pretty much replicate whatever is in there.
RE: Sparkline
I imagine this could be done. One you can check is VitaraChart which is currently available on appstore.
It can do the job though I found it was built using a heavy bundle of libraries including ag-grid.
I've worked with d3.js and I managed to include several type of sparklines in grid cells calling svg shape functions. The key is to bind the proper data format as bullet chart model differs from column or line chart. That may be a challenge in dataViewMapping. Managing to select a sparkline format from a droplist on top of each grid cell would also be a challenge to try
RE: Sparkline
Can I suggest that when you look at providing this functionality you check out Stephen Few's post on best practices for scaling sparklines. See https://www.perceptualedge.com/articles/visual_business_intelligence/best_practices_for_scaling_sparklines.pdf
Also, if you want to be REALLY revolutionary, allow multiple series within sparklines, and allow users to choose different display methods for each series. So they could have budget as a line, historic sales as an area (in the background), and bars denoting sales to date. In one easy glance, a user can then monitor all three things they need to know about a line item. I've been doing this in Excel for years, using some VBA code I wrote to create mini-charts without labels shrunk to the size of a cell, and fed automatically by a PivotTable. The result is pure magic from an information visualisation perspective, as you can see at the images in my comment at https://peltiertech.com/sparklines-for-excel-vs-excel-2010-sparklines-guest-post/#comment-26473
RE: Sparkline
Sparkline capability would be a great feature. Would help move past using Excel for this purpose
RE: Sparkline
Would be Great!