Forum Discussion
Solved
KPI trending axis
Hi, How can I show the YTD value as indicator with Monthly trend axis? I have an example below but the indicator shows the value for November (last item in the table, not the total).
I believe you have to select one or the other. You could use 2 visuals - a sparkline and a card, similar to what I have done here
http://exceleratorbi.com.au/power-bi-public-story-telling/
Yes if your the trend axis is monthly it won't show you YTD totals even if you write YTD Measures!
You may have to use a combination of a chart and the KPI Visual...
Thanks MattAllington! I'm actually interested in the pct change. How does it change colour if it's a card object? And also the Decline/Growth below the figure?
mmmm, my bad - sorry. It is actually the card with states from the visuals gallery https://app.powerbi.com/visuals/show/CardWithStatesBySQLBI1445315565700