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.
Hi,
I have a column of Training Category (Self Request Training, External e-Learning, e-Learning Training, Internal Training).
How can I create a measure to calculate the percentage of each training category by completion status (Completed or In Progress)? and I want to visualize it in donut chart.
Staff Name | Training Category | Training Status |
Staff A | Internal Training | Completed |
Staff B | Internal Training | Completed |
Staff C | Internal Training | Completed |
Staff D | Internal Training | Completed |
Staff A | e-Learning Training | Completed |
Staff B | e-Learning Training | In Progress |
Staff C | e-Learning Training | Completed |
Staff A | External e-Learning | In Progress |
Staff C | External e-Learning | In Progress |
Staff B | Self Request Training | In Progress |
Staff C | Self Request Training | Completed |
Staff D | Self Request Training | Completed |
Pls help.
Thanks
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Thanks Ashish. It's work.
You are welcome.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |