Skip to main content

Power BI

Under Review

Sparkline

Vote (5229) Share
Wenchang Han's profile image

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

Administrator on 28 Jun 2021 09:54:49

Great idea! We'd like to add more visualization types in the future, and the votes that this item receives will help us prioritize them.

Comments (96)
Wenchang Han's profile image Profile Picture

56a0493b 041c-4ae6-8b11-8e9d0ce20f64 on 05 Jul 2020 23:37:31

RE: Sparkline

This live yet?

Wenchang Han's profile image Profile Picture

65c88a40 2a5b-4b65-9906-a3d11145690d on 05 Jul 2020 23:37:24

RE: Sparkline

Yay! We made it to the first page of the PowerBI Ideas site!

Wenchang Han's profile image Profile Picture

a96b2452 b98d-4d03-a9f6-826ec767f44e on 05 Jul 2020 23:37:12

RE: Sparkline

Sparklines in a table is considered standard functionality, everyone else has this. The only reason we went with Tableau over Power BI was because tables/matrix don't support sparklines.

Wenchang Han's profile image Profile Picture

d64b31d4 5712-483b-bf84-e389da768143 on 05 Jul 2020 23:31:39

RE: Sparkline

'Would be very useful, especially when formatting of sparklines is possible:
-chart type: line chart, horizontal bar, column, ...
-colors: and even coloring datapoints (for example with a function)
-adding datalabels and formatting
-add a sparkline in one cell that contains 2 or more measures (for comparison so we don't need multiple columns)

The suggestion of Chris Webb is worth mentioning: using report page tooltips that can be shown in a table/matrix cell:
https://blog.crossjoin.co.uk/2018/08/16/power-bi-sparklines-google-image-charts/

Wenchang Han's profile image Profile Picture

bdee3b7b bf4e-4e65-bd15-4b6c788f126e on 05 Jul 2020 23:29:56

RE: Sparkline

Admin: Can you *please* roll the "In table/matrix visualisations" idea at https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12898575-in-table-matrix-visualisations into this one, so that they get the combined weight they deserve?

Of course, it's not just these 1100-plus-and-countingvoters that think Sparklines are a good idea:
Stephen Few 2006: "Sparklines are ideal for dashboards. Every dashboard vendor ought to support them"

Edward Tufte 2006: "Imagine new software or a new computer display that enormously improved the resolution of data graphics. How wonderful and valuable that would be. Sparklines provide such improvements by design"

Tableau has 'em. Qlik has 'em. Heck, even Excel has 'em...

Wenchang Han's profile image Profile Picture

afd9f607 de69-4700-8b01-f10e78d3f04d on 05 Jul 2020 23:28:47

RE: Sparkline

This was submitted almost 4 years ago. There is already a custom visual "Matrix KPI" available, yes, but not all companies allow custom visuals. So I think I am not alone when saying that a native support would be appreciated.

Wenchang Han's profile image Profile Picture

f59f2225 5262-463e-a846-a230de1764a5 on 05 Jul 2020 23:28:34

RE: Sparkline

Any update on this please??

Wenchang Han's profile image Profile Picture

65c88a40 2a5b-4b65-9906-a3d11145690d on 05 Jul 2020 23:27:03

RE: Sparkline

Microsoft Admin: Can you please roll this idea into https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6795573-sparkline so that they get the combined weight in your prioritization that they deserve?

Wenchang Han's profile image Profile Picture

65c88a40 2a5b-4b65-9906-a3d11145690d on 05 Jul 2020 23:26:57

RE: Sparkline

Agree with maximum85...what kind of Business Intelligence product doesn't have one of the most helpful Business Intelligence visualisations in existence built in? Do you *really* need more votes to prioritize such a basic staple of data viz practitioners worldwide? Compared to Sparklines, most other visuals are *severely* lacking in visual bandwidth. Lack of Sparklines in a Table is the only reason I'm not fullheartedly embracing this product. I can live without almost any other feature for now, but not this one.

Wenchang Han's profile image Profile Picture

2b1d0f41 2e9e-430b-8f49-69cadcfaa286 on 05 Jul 2020 23:26:56

RE: Sparkline

Idea submitted in 2014, and we still don't get this feature until now at 2018

Wth...