Skip to main content

Power BI

Completed

Sparkline

Vote (6151) 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

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)
Wenchang Han's profile image Profile Picture

Power BI Ideas Admin 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

Brian Finn 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

Hilbert 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

Hilbert on 05 Jul 2020 22:51:28

RE: Sparkline

What is the status of this idea?

Wenchang Han's profile image Profile Picture

Power BI User 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

G_Wiz 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

Fred Kaffenberger 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

Gabrielius 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

Naseim 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

sanjeeb.pahadi 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.