Show progress for card (increase & decrease)

[Anonymous]

Hi all,

So I need a card that can show not only sum of value but the progress such as positive/negative progess without setting a target (not a KPI card)

let say the value right now is 100, but maybe it will change to 120 next week. So the value in the card will change to 120 with additional information +20.

any idea ? thanks before 🙂

[v-eachen-msft]

Hi @Anonymous ,

You could calculate the increase/decrease and combine it with your current value.

Here is my test file for your reference. I used calculated column, you could refer to it and use column/measure to get your result.

[Anonymous]

Hi @v-eachen-msft 

Thanks for the input, is it possible to give a conditional formatting if the value negative it will change to red, and positive to green ?

[v-eachen-msft]

Hi @Anonymous ,

Sorry to reply to you after so long.

You could create a new column to set increase/decrease.

Column 2 = 
var a =
CALCULATE(FIRSTNONBLANK('Table'[Column2],1),FILTER('Table','Table'[Column1]=EARLIER('Table'[Column1])-1))
return
'Table'[Column2]-a

Then set rules in conditional formatting.

[amitchandak]

Are you looking for some visual? Can you share some kind screenshot

[Anonymous]

Yes, I'm looking for a visual/chart. I'm sorry I don't have the screenshoot, but it looks like a card with 2 value. Actual Value plus the Delta Value in 1 card.

[az38]

Hi @Anonymous 

if I understand you correct, you can create a measure that calculate data in desired format and put it into the Card visual