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

57ae4af0 1935-475d-a218-e46c506c726f on 05 Jul 2020 23:53:24

RE: Sparkline

Must have

Wenchang Han's profile image Profile Picture

702a6aef 8bf8-418a-aea2-52585e533436 on 05 Jul 2020 23:53:12

RE: Sparkline

Sparkline in Report services why is this taking more than 5 years to implement

Wenchang Han's profile image Profile Picture

e57f7854 9107-4e2e-9a17-77d09a6dec84 on 05 Jul 2020 23:47:45

RE: Sparkline

Not only Sparkline we need much more then this the complete feature of Excel quick KPI & spark lines.

Wenchang Han's profile image Profile Picture

1c248c5a 53b0-4c94-a5d5-43ef110d2fff on 05 Jul 2020 23:47:09

RE: Sparkline

Sparklines for multiple measures in one column + show data labels in tooltip on hover over would make a very refined interactive experience!

Wenchang Han's profile image Profile Picture

65c88a40 2a5b-4b65-9906-a3d11145690d on 05 Jul 2020 23:46:01

RE: Sparkline

Back in November 2018, Amir signalled that MS would figure out a way to "make [sparklines in a matrix]" happen:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#comment-4194677369

Will...Phil Seamark is so sick of me nagging for Sparklines at each PowerBI User Group meeting that he's started not showing up to meetings.

We miss him. Help bring him back. Figure out that way to "make it happen"...even if it's just a simple tweak like allowing us to have rectangular SVG images instead of the current square frame 'placeholder'.

Wenchang Han's profile image Profile Picture

3171db9e 747b-4391-b361-0938889659ae on 05 Jul 2020 23:41:19

RE: Sparkline

Sparkline(and its variants) is a must feature as it is one of the most useful visualisation but we do have a workaround not elegant but opens possibilities to creating complex visualisation .This is by creating a measure with SVG code and categorising this measure as an image URL

Here are examples

https://community.powerbi.com/t5/Quick-Measures-Gallery/SVG-Sparklines-Line/td-p/486271
https://community.powerbi.com/t5/Quick-Measures-Gallery/SVG-Gauges/m-p/490058

This does not work when Report is connected via live connections as the image URL is greyed.

Ultimately , we do want sparklines but we do not have an ETA of when this will be delivered
so please vote for this as well

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36872113-please-extend-data-categories-for-measures-to-live

Wenchang Han's profile image Profile Picture

f0a79457 8489-4309-b4af-9c7c1daea9bc on 05 Jul 2020 23:40:46

RE: Sparkline

Hi All,

I hope the below video show how to do above by using DAX.


https://community.powerbi.com/t5/Quick-Measures-Gallery/SVG-Sparklines-Line/td-p/486271

Wenchang Han's profile image Profile Picture

efdc4285 1ca3-45b5-a1f0-7b3a415723e0 on 05 Jul 2020 23:39:09

RE: Sparkline

I don't understand how this is on the front page of Power BI ideas for Top and Hot, and it hasn't been responded to in over 4 years. Seriously? Are there only 2 people working on the BI team?

Wenchang Han's profile image Profile Picture

dcb778ee 44ae-40ba-be22-a00a0663fe71 on 05 Jul 2020 23:38:07

RE: Sparkline

Sparklines have little value as an individual object and must be in a table to be useful. Other people have mentioned that this is a basic feature that other products have so please, please please get this prioritized and completed ASAP.
Thanks!!

Wenchang Han's profile image Profile Picture

f031a3df a0ec-4b53-a621-5be50e2c863f on 05 Jul 2020 23:37:40

RE: Sparkline

***Dec 2, 2014***
under review · Admin:
Will Thompson (Product Manager, Power BI, Microsoft Power BI) responded ·

It's past Dec 2, 2018. So more than 4 years after this went "under review". I now there is an SVG Graphics viewer on GitHub now.


I know how hard it can be to provide info about timing for adding new features. But a 4-year waiting period for something this basic (and this requested) is a little crazy, and not very useful in a "community".