Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Solved! Go to 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.
@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?
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |