Forum Discussion
KPI trending axis
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...
Little late....
But incase anyone else is looking for an answer to this, you can use the 'Cards With States' custom visual to do this.
Add your measure, add your dimension to the trend axis (I've used month), then go to the format pane and select the data label drop down. Here under 'value', you can select first, last, total etc.
The callout value is now the total YTD, while my trend line shows month intervals.