Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I need some help - I am doing a dashboard and one of the things I need to do is get the T/O percentage of employees who have resigned by average current employees - this is what I have got so far
There is an option to show values as %, Did you try that ?
No I couldnt find an option that allows you to change it to percentages
Pls use this option :
Sorry cant find there anywhere
Looks correct, Did you test with some data ?
Yes I did and I think it is correct only it is not showing as percentages and as I am teaching myself I was not confident I had done it correctly - below is the chart
@Michalison
Without data and the expected results, it a bit hard to propose a solution. any how can you try this and revert.
CountResignations =
VAR _DATE =
DATE ( 2021, 1, 1 )
RETURN
CALCULATE (
COUNTROWS ( Personnel_Records ),
'Personnel_Records'[Resignation] = 1,
'Personnel_Records'[Leaving Date] > _DATE
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Yes I will try this and see if there is a difference thank you
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |