Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
@massar2000 , 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/
@massar2000 , 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/
Thank you
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |