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

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:56:27

RE: Sparkline

I am being asked for this on a matrix that shows the trend for the last four quarters. Would be a great feature.

Wenchang Han's profile image Profile Picture

87378e73 d892-48d9-9220-56ff75d7252b on 05 Jul 2020 22:56:00

RE: Sparkline

I am also looking for this functionality. SSRS did this kind of sparkline in a table visualization really well.

Can quickly convey performance of items visually and can compare to others. Always a wow factor when there is a table full of graphs. Key to any real dashboard.

Wenchang Han's profile image Profile Picture

37635ec5 fc2a-450e-bbb7-20a0e2a455ca on 05 Jul 2020 22:51:40

RE: Sparkline

I want to use this for trend information for each product in a table. Users can see quickly which products performs bad for the lastest months for example.

Wenchang Han's profile image Profile Picture

37635ec5 fc2a-450e-bbb7-20a0e2a455ca on 05 Jul 2020 22:51:28

RE: Sparkline

What is the status of this idea?

Wenchang Han's profile image Profile Picture

efb3a566 3380-4bb7-b942-85b425f12255 on 05 Jul 2020 22:41:01

RE: Sparkline

Please Please Please add this feature, basic analytics such as KPI's + Mini Charts within table data would dramatically help us Power BI Users, currently im trying to use the dataset and connect to excel just to do this, however this means i have to manually refresh a spreadsheet and send it to multiple users and the power bi connection to the data source often fails and can be slow. Also to create basic traffic light KPI's i have to import from PowerPivot, please add these basic features, the latest update with conditional formatting in tables was fantastic, these basic features that we can do in excel are vital

Wenchang Han's profile image Profile Picture

cb1a19d3 ef60-4a58-a6c2-477095aeb997 on 05 Jul 2020 22:39:53

RE: Sparkline

Yes, a much needed capability to catch up to other BI tools. Table rows to include sparklines, but also bullet charts (to show budget, target, actuals, etc) and also some form of KPI indicator with the up/down arrows.

Wenchang Han's profile image Profile Picture

335d95f9 b2f8-451d-8c25-02135088ab30 on 05 Jul 2020 22:39:47

RE: Sparkline

Vote for this idea with over 900 votes: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6795573-sparkline

Wenchang Han's profile image Profile Picture

8017a3c9 1754-40f7-b4aa-69e612b7c2c4 on 05 Jul 2020 22:38:10

RE: Sparkline

Conditional formatting on backgrounds is nice, but it would be have TEXT formatting (font weight, color).

Wenchang Han's profile image Profile Picture

693441f9 5525-4480-b4c4-50cdba5799fe on 05 Jul 2020 22:35:54

RE: Sparkline

This should have similar editing functionality like in Excel, where you can add 'Marker' for negative points

Wenchang Han's profile image Profile Picture

54c42f6b 4cd8-4a0a-85ff-0c5387fd2676 on 05 Jul 2020 22:35:23

RE: Sparkline

conditional formatting is done. But we need data bars and sparklines or I would say charts.