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.
Empoyee | Work Date | Category | Work Hours | Color Code |
Jane Dow | 1/1/2019 | Labor Salary | 8 | Green |
Jane Doe | 1/5/2019 | Vacation | 10 | Orange |
John Dow | 2/2/2019 | Holiday | 12 | Black |
Jane Dow | 2/15/2019 | Labor Daily | 8 | Green |
Jane Doq | 1/31/2019 | Labor Hourly | 10 | Green |
John Doe | 1/31/2019 | Missing Time | 0 | Pink |
Solved! Go to Solution.
@Anonymous , created this file you. Hope this works for you
https://www.dropbox.com/s/5xubpa67hdaquxg/ColorMeasure.pbix?dl=0
Appreciate your Kudos.
@Anonymous
In diverge, you can three colors, but you can four colors based on condition. Refer
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
@amitchandak I have read this document several times. The options in this document does not work as I will need to change the background colors for work hours based on the category field. This does not solve my issue. Thanks
@Anonymous , created this file you. Hope this works for you
https://www.dropbox.com/s/5xubpa67hdaquxg/ColorMeasure.pbix?dl=0
Appreciate your Kudos.
@amitchandak Thank you so much! This is what I was looking for, I did not know how to write the DAX formula! You rock!!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |