Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to create a KPI monthly trend line Chart that shows just the percentage the completed Activations for each month. The closest I have currently to is the following showing this in a 100% stack bar graph but trying to show this in a line graph that will show the trend more clearly.
Close date Activation Status
dd/mm/yy Complete/Failed
Solved! Go to Solution.
Hi @howie2293 ,
We can create a measure to meet your requirement:
KPI = CALCULATE(COUNTROWS('Table'),'Table'[Activation Status]="Complete")/COUNTROWS('Table')
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.
Best regards,
Hi @howie2293 ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
Hi @howie2293 ,
We can create a measure to meet your requirement:
KPI = CALCULATE(COUNTROWS('Table'),'Table'[Activation Status]="Complete")/COUNTROWS('Table')
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.
Best regards,
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |