Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I have task like in azure devops we have work details ,there whenever employee having morethan 80 hours of tasks it will show red colour like below.
Now my task is same like i have to show in Power bi report.
Please help here .
Hi @hariram2 ,
It seems that you want to configure conditional formatting for the tasks, you can refer the following links to get it:
Apply conditional formatting in tables and matrixes
Power BI Conditional Formatting for Matrix and Table Visuals
If the above one can't help you get the desired result, please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Thanks for the reply@ yingyinr
Below is the table.
Assigned to | Remaining Work |
A | 50 |
B | 60 |
C | 80 |
D | 90 |
My sprint plan for every 2 weeks
Ex:srint 1 :29th august to 9th august 2022
Having total 80 work hours for each employee for every sprint
I am having slicer to select every sprint
,Example:Today my sprint started means everyone should show 80 hours if morethan 80 hours it could show red mark
One more example:if i will check tomorrow means everyone shoud show 72 hours ,if morethan 72 hours it could show red mark.
Plz help here.
Below is the screenshot like today sprint started ,but basically he should have 80hours but remaining work hours having more than 80 hours so thats why it is hsowing red mark in azure devops
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |