cumulative measure in sparkline

[rufmau68]

Hi

im new in pbi

i need to use sparkline in table .

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

that works good but only with normally measure not in comulative measure...

[amitchandak]

@rufmau68 , is your cumulative measure working correctly ? Can you share formula .

Also check this, seem like a same approch - https://www.youtube.com/watch?v=xLD8HKwPWHE

Can you share sample data and sample output in table format?

[rufmau68]

Yes i use that tutorial to do it , but if U see, in the sparkline he dont shows a cumulated measure.

i have to shows a cumulated value to obtain a sparkline like this (the measure values allways goes up) 

here U download a data sample

https://drive.google.com/file/d/1xagsTWGBYt7SsHjQTcxUEeSBplcfcfUk/view?usp=sharing

[Anonymous · Accepted solution]

Hi @rufmau68 

It seems that show running total in sparkline is not supported in Power BI.

You can try to create a cumulative total measure and then use it to build a line chart.

I add a YearMonth column in your sample.

YearMonth = Foglio4[Anno]*100+Foglio4[Mese]

Measure:

Running Total = SUMX(FILTER(ALL(Foglio4),Foglio4[Codice WBS]=MAX(Foglio4[Codice WBS])&&Foglio4[YearMonth]<=MAX(Foglio4[YearMonth])),Foglio4[Rendicontato Consuntivo])

 

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：Sparkline

Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.