Need help with visualization

[sbadiger3]

Hi everyone, I hope everyone is doing well. I need a help with a visual. 
Business Case: 
Data - I have a data related to spends. I have date, invoice amount. I have created a measure for calculating invoice amount for previous month. The code for calculating prev month invoice used is 

Prev Month Spends =

CALCULATE(

    SUM(Spends[Invoice Amount]),

    PREVIOUSMONTH(Spends[Billing Period])

)

Requirement - I need to show some kind of visual where in the first line i need to show the invoice amount for current month (month selected in slicer) and below that I need to show the invoice amount for previous month. Current month needs to have conditional formating based on the condition that "if current month invoice is less than the previous month, then current month invoice value needs to be displayed in green, else red" 

 
It should look something like the snapshot which I will be attaching below.  

Can someone help me to achieve this?

Thanks in advance! 

[Anonymous]

Hi @sbadiger3 ,

If you want to show values in K or M units, I suggest you to combine two visuals to show value and icon.

Measure:

Arrow = 
VAR _ARROWUP =  UNICHAR(9650)
VAR _ARROWDOWN = UNICHAR(9660)
VAR _CURRENT = SUM(Spends[Invoice Amount])
RETURN
IF(_CURRENT < [Prev Month Spends], _ARROWDOWN,_ARROWUP)

Color = 
VAR _CURRENT = SUM(Spends[Invoice Amount])
RETURN
IF(_CURRENT < [Prev Month Spends],"Green","Red")

Create an arrow card visual and group it with current amount crad visual. Then use conditional formatting in both visuals with [Color] measure.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.