Forum Discussion
Table comparison between current and last year
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
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/
2 Replies
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/