Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table showing material utilization percentages over multiple fiscal years. I would like to apply conditional formatting to this table so that if the utilization percentage from one year is greater than the previous year it will show green, and red if it is lower. Below is the table I am working with. Any help you can offer would be greatly appreciated. Thank you in advance for your time!
Solved! Go to Solution.
@T_Buck_1027 I got it figured out.
First I created a measure using the SAMEPERIODLASTYEAR function to calculate the average utilization from the pervious year
utilizaiton LY = CALCULATE( [utilization] , SAMEPERIODLASTYEAR( [date] ))
Then I created a measure like you suggested to calculate the difference and eliminate false data caused by blanks
difference utilization = IF( ISBLANK( [utilization LY] ), BLANK(), [utlization] - [utilization LY] )
You can start by creating a measure that calculates the difference between one year and another. When you apply the conditional formatting to the field, you can choose to conditionally format that field by a different field.
Ex: Difference2020 = FY2020 - FY2019
Format --> Conditional Formatting --> Choose field in dropdown --> advanced controls --> select rules under "Format by" dropdown --> select Difference2020 under the "Based on field" dropdown --> set your rules
I hope this helps, let me know if you need clarification.
@T_Buck_1027 I got it figured out.
First I created a measure using the SAMEPERIODLASTYEAR function to calculate the average utilization from the pervious year
utilizaiton LY = CALCULATE( [utilization] , SAMEPERIODLASTYEAR( [date] ))
Then I created a measure like you suggested to calculate the difference and eliminate false data caused by blanks
difference utilization = IF( ISBLANK( [utilization LY] ), BLANK(), [utlization] - [utilization LY] )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |