Table comparison between current and last year

[Anonymous]

I am using the table to compare the current month and the same month last year. Here is the DAX I used for both columns

Actual hours = sum(submissionCycleTime[# of actual hours])

LY Submission time = CALCULATE([Actual hours],SAMEPERIODLASTYEAR(DateMasterT1[Date]))

I want the actual hour's columns to show green, yellow, and red arrows depending on the below calculations

((LY Submission time – Actual hours)/LY Submission hours) *100.

The color code for the arrows as follows

Is there a way to do that.

Thanks in advance

Regards,

Majed

[amitchandak · Accepted solution]

@Anonymous , you can create a color measure like

Switch(true(),
[change%] <.16 , "Red" ,
[change%] <.18 , "yellow" ,
"green"
)

The same way you can create a unichar measure and combine both

refer example

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

[Anonymous]

Thank you