Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Show progress for card (increase & decrease)

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, b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
v-eachen-msft
Community Support
6 years ago

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.