cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cedric_basuel
New Member

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).

 

KPI.JPG

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: 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/

 

 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Sean Community Champion
Community Champion

Re: KPI trending axis

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...

 

KPI Visual.png

View solution in original post

8 REPLIES 8

Re: 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/

 

 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Sean Community Champion
Community Champion

Re: KPI trending axis

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...

 

KPI Visual.png

View solution in original post

Aleli
Frequent Visitor

Re: KPI trending axis

Hi Matt,

 

Awesome blog. Can you tell me how you did the Growth and Decline visual? It's like KPI visual without tick marks. Thanks!

Highlighted

Re: KPI trending axis

Each teal box is 5 objects

1 the box itself

2 the kpi item

3 a picture icon

4 the pct change, which is a card object rendering a pact chg vs last year measure

5 the line, which is a spark line custom visual from the visuals gallery

 

Does that help?



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Aleli
Frequent Visitor

Re: KPI trending axis

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?

Re: KPI trending axis

mmmm, my bad - sorry.  It is actually the card with states from the visuals gallery  https://app.powerbi.com/visuals/show/CardWithStatesBySQLBI1445315565700



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Aleli
Frequent Visitor

Re: KPI trending axis

Thank you so much @MattAllington! This is exactly what I need. Much appreciated.

 

Regards,

Aleli

PoppyB
Regular Visitor

Re: KPI trending axis

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. 

 

 Last Month Total.PNGTotal Value.PNGYTD Total.PNG

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors