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

87d286d3 d138-446a-a938-7eb729e6065b on 05 Jul 2020 22:24:28

RE: Sparkline

This is an essential capability to maximize space utilization - if I could give this enhancement all (ok, maybe not all, but a lot of them) my votes, I would!

Wenchang Han's profile image Profile Picture

ab782a73 134b-4713-927a-920d70446e02 on 05 Jul 2020 22:23:31

RE: Sparkline

It would be great to add conditional formatting to matrix visualizations too.

Wenchang Han's profile image Profile Picture

4b9ea494 b129-4220-897a-8410d5c9b2ec on 05 Jul 2020 22:22:40

RE: Sparkline

Ah, okay, so Sparklines in a table with associated indicators doesn't yet exist in Power BI? Am wanting to make a scorecard with Actuals, Targets, historic trends and indicators, but I fear I may be overselling the capability at the moment.

Any ideas on how I could create the following visualisation:

http://postimg.org/image/cgbclkfsb/

Thanks!

Wenchang Han's profile image Profile Picture

9569a2b5 b0aa-457f-99c7-3e7ebd2603f5 on 05 Jul 2020 22:21:37

RE: Sparkline

This is by far one of the most powerful dashboard features promoted by Stephen Few. Here is an example of what in-cell charts look like: http://blog.xlcubed.com/wp-content/uploads/2013/08/FinanceSShot.png or https://community.tableau.com/ideas/1181

This is the kind of feature that separates mediocre eye-candy come no substance dashboard from ones that augment effective decision making. Please consider this feature as this enhances data:ink ratio better than any other visual in existence. In cell charts like spark lines and bullet graphs are unbeatable when used in a pivot table.

Wenchang Han's profile image Profile Picture

23a5b8e4 b8c5-486a-9b1e-ec82914a3f2c on 05 Jul 2020 22:21:13

RE: Sparkline

It's not "power" BI without sparklines, Will. :D

Wenchang Han's profile image Profile Picture

05cb2166 2d56-e711-80fd-c4346bac219c on 05 Jul 2020 22:18:32

RE: Sparkline

Can you make it easy for these to be for a rolling 13 month period, i.e. Show current month, plus preceding 12 months so that you can compare with equivalent month in previous year and see the trend since then.

Wenchang Han's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:17:31

RE: Sparkline

Really need the ability to add conditional formatting, data bars and sparklines to table and matrix objects

Wenchang Han's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:17:11

RE: Sparkline

Great idea, but please include the whole deal. That is: a) Line Sparkline; b) Column sparkline; and c) Win/Loss sparkline

Here is what I mean: http://imgur.com/oLcMw9q

Wenchang Han's profile image Profile Picture

4ebe8852 e0c5-4fd0-8f4e-4c8fbd55cdfd on 05 Jul 2020 22:16:47

RE: Sparkline

It would be important to have drill capability and to have each metric measured independently. Cost increases are bad, but sales increases are good, so marking decreases in red (for example) is misleading.

Wenchang Han's profile image Profile Picture

f2f782bd d0e7-42f8-b44e-68828bb89f53 on 05 Jul 2020 22:11:17

RE: Sparkline

It seems that sparklines are all the buzz these days. The business needs it.