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.
I have a matrix with one numeric value and a sparkline on that value.
There is also a slicer (Year) that is also being used as the X-axis on the sparkline. What I'm trying to do is select only one value from the Year slicer, but show the previous five years on the sparkline X-axis. The image below shows what the matrix looks like when two Years are selected - the sparkline has two data points. However, the Area Value measure is also aggregated for the two Years. Any ideas as to how I might select only one Year from the slicer (thus, the Area Value measure represents just the one Year), but show multiple Year data points on the Area Value sparkline?
Thanks.
Hi @jblindsey ,
Based on your description, the built-in sparkline of power Bi does not support dynamic change of axis. Please try DAX for svgimages sparkline.
Please refer to:
https://community.powerbi.com/t5/Desktop/Dax-for-SVGImages-sparkline/m-p/1092683
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Liang. I will take a look at SVGImages to see if it will work for me.
@jblindsey , if you want select one year and want to show data for 5 year, you need have an independent date/year slicer and use that to get 5 year data measure
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -60) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Thank you Amit. I've been using your information to see if it will work in my scenario.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |