Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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. A...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    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

    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.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

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]

Finally, i add a rectangle shape

 

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.