cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Mezmarianne Regular Visitor
Regular Visitor

Best KPI visual for target comparison

I have to add a visual to a report showing SALES YTD and BUDGET YTD. I use the standard KPI visual.

 

But the client would like to also show the difference in currency - not just the percentage.

And they would also like to have the percentage to say 97,4% in stead of -2,6%

 

I have added the difference as a card, but that is not very elegant.

 

Does anyone have a suggestion for a better visual. ( I have downloaded 8 different from the store, but either I am not using them correctly or they don't really show it the way the customer wants.)

 

2019-04-23_JDM_Screenshot109.pngSomething like this....

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Best KPI visual for target comparison

Hi @Mezmarianne 

i can get another KPI visual, please see if it satisfies you much more.

Create measures

card_goal = "Goal: "&"kr"&"."&[Measure-budget ytd]&"("&FORMAT([percentage],"0.0%")&")"

card_diff = "Difference: "&ABS([difference])&IF([difference]<0,"-")&"kr"

Add each measure in a one-row card visual

8.png

Please download my pbix to learn more details.

one the page 2, click on the card visual and see its format pane.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Best KPI visual for target comparison

Hi @Mezmarianne 

I create measures and add these measure in a Muti-row card.

Assume SALES YTD and BUDGET YTD are measures

difference = [Measure-sales ytd]-[Measure-budget ytd]

percentage = [Measure-sales ytd]/[Measure-budget ytd]

6.png

Finally, i add a rectangle shape

7.png

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team
Community Support Team

Re: Best KPI visual for target comparison

Hi @Mezmarianne 

i can get another KPI visual, please see if it satisfies you much more.

Create measures

card_goal = "Goal: "&"kr"&"."&[Measure-budget ytd]&"("&FORMAT([percentage],"0.0%")&")"

card_diff = "Difference: "&ABS([difference])&IF([difference]<0,"-")&"kr"

Add each measure in a one-row card visual

8.png

Please download my pbix to learn more details.

one the page 2, click on the card visual and see its format pane.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 156 members 1,742 guests
Please welcome our newest community members: